Extracting Text within a String

[Anonymous]

I have a column with various string text. My target is to extract a very specific  portion of the text from the string. Please see screenshot below. 

Existing Column	Desired Column
FS-180604031(M10372No Charge), FS-170718047(M10372Charge), FS-170718047(M10372Preventative Maint), FS-170426043(M10372Sales Support),	No Charge, Charge, Preventative Maint, Sales Support
*FS-170815075(M124Prev Maint - New Machine Sale), FS-170613036(M124Installation (New)),	Prev Maint - New Machine Sale, Installation (New)

I have tried to extract by delimiter but for some reason, the output would only provide 1 of the target items and drop off all the others. I have also tried to extract by the number of characters but there are different numbers of characters. 

Any guidance as to how you would approach this will be greatly appreicated!

[v-cherch-msft]

Hi @Anonymous

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here.

Regards,

Cherie

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may use Split column function. Below is the document about Text Extraction for your reference. Attached the sample file.

https://www.mssqltips.com/sqlservertip/5564/text-extraction-using-the-m-language-with-power-bi/

Regards,

Cherie