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
Solved! Go to Solution.
hi @aka_ash ,
Not too sure about the formula tool, but you can accomplish this with Regex.
hope this helps!
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