Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Extract String after certain symbol

Hi Expert

 

How would you extract the string text after the "-" and Second space, into a new column. Either using a calculated column or in M-Script as part of the applied steps.

 

001 - Hello World

232 - Here it is

 

So i need all the wording after the dash and second space. 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    • Anonymous's avatar
      Anonymous
      Not applicable

      Excellent, feedback. Works

      • Anonymous's avatar
        Anonymous
        Not applicable

        you are welcome

  • Anonymous's avatar
    Anonymous
    Not applicable

    if this pattern is consistent , whey dont you try column by example