Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extracting String From Column into New Column

Hello, I am unsure of how to extract the values beginning with CRQ (like 'CRQXXXX' or CRQ00002382610) into a new column.  Currently I have the column:     I would like to create a new column:...
Need Help
  • nandic's avatar
    nandic
    6 years ago

    Hi Anonymous ,

    Once published i have seen last row of your question where it is said that direct query is used. In this case, the best option is to make this column on database table level.

     

    If Power Query (depending on database) allows extract options, below are steps:

    Select the column (Issue Title) > Extract > Text between delimiters 
    For delimiter enter space.

     



    Cheers,
    Nemanja