Multiple replace within a field and sort

[aka_ash]

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

Value	Replacement Value
ABC.ZX.QWE	Z
ABC.FG.WER	FG
ABC.RE.ERT	R
ABC.QW.TYU	Q
ABC.FD.POI	FD
ABC.FC.OIU	FC

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

[paulfound · Accepted solution]

Hi @aka_ash 

Think this is what your trying to do.

Let me know how you get on.

[aka_ash]

This worked for me, thanks @paulfound.

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

[paulfound]

@aka_ash 

No it isn't the summary tool doing the sorting. Its the order of the replacement table in reverse as its joined that dictates the order.

Summary doesn't change the order.

Paul