Format data for CSV

[Marissa Stradley]

What is the easiest way to get data into format like record 38 with notepad++?
Thanks in advance.

[Michael Vincent]

@marissa-stradley

Record a macro.

1. Put cursor before the “39”
2. Macro => Start Recording
3. Press the Shift key and press the down arrow 10 times (so that you’ve highlighted the lines from “39” to the blank line before “40”)
4. Edit => Line Operations => Join Lines
5. Press the down arrow and Home key so the cursor is now in front of the “40”.
6. Macro => Stop Recording

Now use the Macro => Run a Macro Multiple Times… menu entry to finish the file.

Cheers.