Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • More efficient way to moss p_name, match("([0-9])") regex in a very large dataset?

    Good morning,
    I need to find the first instance of [0-9] in a string. I tested the following and it works:

    moss ID, match("([0-9])") regex


    However ID is often a long string and the data set is extremely large. Since all I need is _pos1 is there a more efficient way of doing this?

    Thanks.


    ID
    0 0 1 2 Hello 2
    2 hi 3 2
    my name
    33 12
    there

  • #2
    And I answered my now question:

    moss ID, match ("[0-9]") regex max(1). Thanks.

    Comment


    • #3
      Thank you for posting your answer, to the benefit of others who in searching the web may someday be directed to this topic. Also to the benefit of those of us reading this now who have not made extensive use of the moss command available from SSC.

      Comment

      Working...
      X