Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

extract a string with a column

Hi   I have a column in my dataset that looks like the below. What I want to do is create a new column that extracts the R & L number sequence. For example on the first rows it would look like R105...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous ad d new custom column in edit query using following M code

     

    Change [Data] column with your actual column name

     

     Text.BetweenDelimiters([Data], " ", " ", 4, 0)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous your requested result doesn't match with your sample dataset. can you double check and rewrite your post.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous is this looks correct?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes parry2k  thats perfect! How did you do that?

       

      Thanks :)

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        Anonymous ad d new custom column in edit query using following M code

         

        Change [Data] column with your actual column name

         

         Text.BetweenDelimiters([Data], " ", " ", 4, 0)