Remove the duplicate values from a text rule input?

Question

My requirement is to remove the duplicate values from a rule input of type text. Here is a sample input and output. 
 Input: Hello hello Hello there there past pastures 
 Output: Hello there past pastures

Stewart Burchell · Accepted Answer

There maybe more elegant ways, but something like this: 
 a!localVariables(
 local!trimmed: fn!trim(ri!inputString),
 local!split: fn!split(local!trimmed, " "),
 local!lower: fn!lower(local!split),
 local!union: fn!union(local!lower, local!lower),
 local!result: a!forEach(
 items: local!union,
 expression: if(
 fv!isFirst,
 concat(fn!proper(fv!item), " "),
 concat(fv!item, " ")
 )
 ),
 fv!concat(local!result)
) 
 Notes: 
 
 fn!trim() removes all unnecessary spaces (in case you have more than one space between the individual strings) 
 fn!split() breaks up the input strings into an array so they can be processed independently 
 fn!lower() makes all of the strings into lower case so that, for example, all "Hello" items are the same 
 fn!union() removes duplicate strings from the array 
 the a!forEach() allows us to treat the very first item in the array differently from the others, so we can use fn!proper() to capitalize the first letter for just the first string. For all items we add single space so that... 
 ...we can then concatenate all of the items in the array to a single output string

Richard Michaelis · Answer

in any case there is no "simple" method or function to archive that. 1.) You need to cut it into pieces (word for word) 2.) compare the different values to each other 3.) remove the values you don't want to have. Spontanously I would suggest an expression with extract(), search() perhaps cleanwith() Sorry no final solution for that issue on hand. -> docs.appian.com/.../Appian_Functions.html

Harsha Sharma · Answer

you can first do split() on spaces and then take union() of the split array to filter out repeated strings. Lastly concat the result with spaces in between.

Remove the duplicate values from a text rule input?

Top Replies