Community
    • Login

    Format data for CSV

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    2 Posts 2 Posters 922 Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Marissa StradleyM Offline
      Marissa Stradley
      last edited by

      Screen Shot 2022-01-03 at 3.39.40 PM.png
      What is the easiest way to get data into format like record 38 with notepad++?
      Thanks in advance.

      Michael VincentM 1 Reply Last reply Reply Quote 0
      • Michael VincentM Offline
        Michael Vincent @Marissa Stradley
        last edited by

        @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.

        1 Reply Last reply Reply Quote 3

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • First post
          Last post
        The Community of users of the Notepad++ text editor.
        Powered by NodeBB | Contributors