DataMystic

Hi,

I would like to know if it is possible to sort all words in each line of a text file (kind of a word to text, sort words, put them back in one line and then back to the output line). I am trying to do a data cleaning before a fuzzy lookup and i have the reference data sorted, i.e, the file and the words of each record. Is this possible? Thanks.

Regards,

Paulo

Yes you can, you need to restrict to each line in turn, then inside this, apply a Text to Word List filter, followed by a sort, followed by a search/replace of cr/lf with a space. Let me know if you need more help.