Format data for CSV
What is the easiest way to get data into format like record 38 with notepad++?
Thanks in advance.
Record a macro.
- Put cursor before the “39”
- Macro => Start Recording
- 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”)
- Edit => Line Operations => Join Lines
- Press the down arrow and Home key so the cursor is now in front of the “40”.
- Macro => Stop Recording
Now use the Macro => Run a Macro Multiple Times… menu entry to finish the file.