Hi, I am looking to do a multiple find\replace of text within a field and then sort the values by alphabetical order. I thought i could use a replace formula with "AND" statements but couldn't get it to work, hoping someone can advise. I have a sample text replacement table below as well as sample data and desired output below ValueReplacement ValueABC.ZX.QWEZABC.FG.WERFGABC.RE.ERTRABC.QW.TYUQABC.FD.POIFDABC.FC.OIUFC DataReplaced data outputDesired output (Sorted)ABC.ZX.QWE,ABC.QW.TYU,ABC.FC.OIUZ,Q,FCFC,Q,ZABC.FG.WER,ABC.RE.ERT, ABC.FD.POI, ABC.QW.TYUFG,R,FD,QFD,FG,Q,RABC.QW.TYUQQ Thanks in advance, Ash

Multiple replace within a field and sort

Hi,

I am looking to do a multiple find\replace of text within a field and then sort the values by alphabetical order.

I thought i could use a replace formula with "AND" statements but couldn't get it to work, hoping someone can advise.

I have a sample text replacement table below as well as sample data and desired output below

Data	Replaced data output	Desired output (Sorted)
ABC.ZX.QWE,ABC.QW.TYU,ABC.FC.OIU	Z,Q,FC	FC,Q,Z
ABC.FG.WER,ABC.RE.ERT, ABC.FD.POI, ABC.QW.TYU	FG,R,FD,Q	FD,FG,Q,R
ABC.QW.TYU	Q	Q

Thanks in advance,

Ash

Input

Regex

Expression

Think this is what your trying to do.

Let me know how you get on.

Think this is what your trying to do.

Let me know how you get on.

This worked for me, thanks @paulfound.

Just curious, does the concatenate in the Summarize tool automatically sort alphabetically?