Community
    • Login

    Deleting a character fro the same place (end of line)

    Scheduled Pinned Locked Moved General Discussion
    edit delet eol
    3 Posts 2 Posters 364 Views 2 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.
    • Frankie DeschachtF Offline
      Frankie Deschacht
      last edited by

      Hello,
      I have a file (CSV) with a good few 1000 records in it.
      My problems is, I need to get rid of a semicolon character at the end of all lines.

      Is there any possibility of doing that in NPP, thus avoiding having to do it by hand one line by one?

      Your help will be much appreciated.

      PeterJonesP 1 Reply Last reply Reply Quote 0
      • PeterJonesP Online
        PeterJones @Frankie Deschacht
        last edited by PeterJones

        @Frankie-Deschacht ,

        FIND = ;$ (the $ means “end of line”, not the literal character, in a regular expression)
        REPLACE = emtpy
        SEARCH MODE = regular expression

        -—

        Do you want regex search/replace help? Then please be patient and polite, show some effort, and be willing to learn; answer questions and requests for clarification that are made of you. All example text should be marked as plain text using the </> toolbar button or manual Markdown syntax. Screenshots can be pasted from the clipboard to your post using Ctrl+V to show graphical items, but any text should be included as literal text in your post so we can easily copy/paste your data. Show the data you have and the text you want to get from that data; include examples of things that should match and be transformed, and things that don’t match and should be left alone; show edge cases and make sure you examples are as varied as your real data. Show the regex you already tried, and why you thought it should work; tell us what’s wrong with what you do get… Read the official NPP Searching / Regex docs and the forum’s Regular Expression FAQ. If you follow these guidelines, you’re much more likely to get helpful replies that solve your problem in the shortest number of tries.

        1 Reply Last reply Reply Quote 1
        • Frankie DeschachtF Offline
          Frankie Deschacht
          last edited by

          Peter Jones,
          That is brilliant.
          Thank you ever so much.
          You solved a HUGE problem for me.

          1 Reply Last reply Reply Quote 2

          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