Main Menu

Editing Question

Started by kryten, February 04, 2013, 12:40:27 AM

Previous topic - Next topic

kryten

Hi,

From time to time I have to work with CSV type data and in many cases the column editing mode of HippoEDIT is very handy, for heavy lifting of the data I tend to use Powershell or Perl or Ruby.

However sometimes I need to make a quick edit on just a line of CSV Eg:-

dog,cat,mouse,elephant

Is there a quick way for me to split these data onto own lines based on the delimiter? :

dog
cat
mouse
elephant

Natively in HippoEDIT?

Usually the data I work with would be many columns/fields but this serves to illustrate.

Thanks,
Stuart



alex

Hi Stuart,

and simple replace all "," to "\r\n" (in Selection / in Document) in regexp mode will not help?
If not, you can add simple script, doing this in 1.50 and add it as a tool or do a script plugin and have native command.

BR, Alex.
HippoEDIT team
[url="http://www.hippoedit.com/"]http://www.hippoedit.com/[/url]