Extract specific data from fields

[aka_ash]

Hi,

I looking to extract extract specific data within fields, the data delimited with commas so can be split via Text to Columns however i was wanting to know if this can be done via a formula?

Below is similar to what I looking to achieve, concatenate any data with AB.*.

Data column (Input)	Output (AB.*)
ZX.AS, AB.CD.EF,AB.EF.CD,QWE,AB.MN.AS,DATA	AB.CD.EF,AB.EF.CD,AB.MN.AS
DATA ,QWE,AB.MN.AS	AB.MN.AS
AB.EF.CD	AB.EF.CD

Thanks in advance,

Ash

[bpatel · Accepted solution]

hi @aka_ash ,

Not too sure about the formula tool, but you can accomplish this with Regex.

hope this helps!

[aka_ash]

Hi @bpatel,

Thank you for this, that is the outcome I am looking for.

I will have to learn how to do this with the Regex formula.

Thanks again,

Ash