Sort all words on each line of a text file

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

T34PPPC
Posts: 1
Joined: Tue Jan 30, 2007 5:17 am

Sort all words on each line of a text file

Postby T34PPPC » Tue Jan 30, 2007 5:23 am

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

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Wed Jan 31, 2007 8:35 am

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 3 guests