Sort characters within a field

[slckkrky]

Hello everyone

I am trying to sort field characters regardless of what value is in the field  i.e. "Value= Chocolate", I need "accehloot" or "Value= apple2", I need "2aellp"7

Is there any way to do that?

Thank you in advance

[DataNath · Accepted solution]

Hey @slckkrky here's how I'd go about this. We just split the records into individual characters before sorting them and then re-concatenating to get back to a single cell value. Hope this helps!

[Rags1982]

Agree with @DataNath 
Out of curiosity, why would you want to do this? 

[slckkrky]

I am investigating new ways to fuzzy match values. I will sort all characters of multiple fields , create a new field to match and see if the result will get any better.