Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
6 years ago
Solved

Extract Text String from column to a new column

Hi 

 

I have a table called REPAIRS with a column called JOB_DETAILS.  I need to extract certain text from this column to a new column. The list of text words that I need to extract are as follows ,

(Contractor)
(Parts)
(Scope)
(Book)

 If the words above do not appear in the Job_Details column I need the new column to be blank

The comas need to be included.

 

thankyou

 

RIchard

4 Replies

    • cottrera's avatar
      cottrera
      Post Prodigy

      Hi thanks for the quick response. Yes that right only one of these words will ever appear per row at any time.

       

      Richard

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support

        Hi cottrera ,

         

        Would you please try to use condition column in query editor:

         

         

        Best Regards,

        Dedmon Dai