Author Topic: Editing Question  (Read 2026 times)

Offline kryten

  • Registered User
  • Newbie
  • *
  • Posts: 20
  • Karma: +2/-0
Editing Question
« on: February 04, 2013, 12:40:27 AM »
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



Offline alex

  • Developer
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2222
  • Karma: +37/-3
    • HippoEDIT
Re: Editing Question
« Reply #1 on: February 04, 2013, 10:22:27 AM »
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.