Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Remove rows that contain 1-999 from the first 3 numbers of the row.

    Help wanted · · · – – – · · ·
    3
    10
    95
    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.
    • Eric Tilley
      Eric Tilley last edited by

      Remove rows that contain 1-999 from the first 3 numbers of the row.

      1 Reply Last reply Reply Quote 0
      • Terry R
        Terry R last edited by

        @Eric-Tilley said in Remove rows that contain 1-999 from the first 3 numbers of the row.:

        Remove rows that contain 1-999 from the first 3 numbers of the row.

        Could you give an example of a few lines? I think it’s possible with a regular expression, however what is the character that separates the words, a space, comma, something else. Examples are like a picture, they speak a thousand words.

        Read the post in the FAQ section (FAQ Desk: Formatting Forum Posts) about how to insert examples into posts correctly.

        Terry

        1 Reply Last reply Reply Quote 1
        • Eric Tilley
          Eric Tilley last edited by

          dc2577ac-e854-40dd-a743-86cb536bf12c-image.png

          1 Reply Last reply Reply Quote 0
          • Terry R
            Terry R last edited by

            Well that was helpful. I can see the numbers contain a decimal point and the comma is the “delimiter”.

            So another question, you say 1-999 in the first 3 numbers. Since your example shows some lines with the first number like that but no others (in the first 3), do you mean as long as JUST 1 in the first 3 is between 1-999 or do ALL 3 need to be 1-999. And since there are decimal numbers involved, do you really mean 1-999.999999999, so in essence as long as not 1000 or more?

            Terry

            1 Reply Last reply Reply Quote 1
            • Eric Tilley
              Eric Tilley last edited by

              Yes your correct, I only need numbers 1000 and up.

              Terry R PeterJones 2 Replies Last reply Reply Quote 0
              • Terry R
                Terry R @Eric Tilley last edited by

                @Eric-Tilley said in Remove rows that contain 1-999 from the first 3 numbers of the row.:

                Yes your correct, I only need numbers 1000 and up.

                You’re a person of very few words aren’t you?

                There were 2 questions and whilst you answered the 2nd, so anything below 1000, meaning a number like 999.999 would be counted, you missed the first question. So all 3 below 1000 to have row removed, or any one of the first 3 below 1000 to have row removed?

                Remember we are willing to help, but you need to be able to provide the information. Having to go back and forth asking questions isn’t ideal and perhaps you should consider that if you need help in the future. As much information you can supply the easier it all works out in the end.

                Terry

                1 Reply Last reply Reply Quote 2
                • PeterJones
                  PeterJones @Eric Tilley last edited by

                  @Eric-Tilley ,

                  You may benefit from using the Template for Search/Replace Questions that I just posted.

                  1 Reply Last reply Reply Quote 1
                  • Terry R
                    Terry R last edited by

                    @PeterJones said in Remove rows that contain 1-999 from the first 3 numbers of the row.:

                    You may benefit from using the Template for Search/Replace Questions that I just posted.

                    About time @PeterJones ;-)))). I was looking for a suitable FAQ post to link here thinking we already had it. Then I was looking for one your reply posts so I could plagiarise your nice bit of “bottom text”.

                    Cheers
                    Terry

                    1 Reply Last reply Reply Quote 0
                    • Eric Tilley
                      Eric Tilley last edited by

                      Sorry for using the wrong format. Ive reposted a new thread, hopefully its done they way it needs to be.

                      1 Reply Last reply Reply Quote 0
                      • Terry R
                        Terry R last edited by

                        OP has continued this (albeit with some changes in request) in this post.

                        Terry

                        1 Reply Last reply Reply Quote 0
                        • First post
                          Last post
                        Copyright © 2014 NodeBB Forums | Contributors