Formula required for removing unwanted characters

Question

Hello,

I'm new to Alteryx and require help with cleaning my dataset. I've recently been tidying unwanted characters in my dataset, largely using ReplaceChar in the Formula tool. This has been great up until now as I have two fields that are the following:

A:

B:

In both instances, I want the 1,285 and 366 to remain in the column, and the rest of the text to be discarded. I initially began to use the LEFT function but this would be problematic as the remainder of the data in the column is good and contains data ranging from 3-6 characters (e.g. 16,558), so this data would have been changed by the LEFT function, which I don't want.

Thanks,

KA

arundaka02 · Accepted Answer

Just revisited the data and decided to parse the column with Text to Columns tool with the character 's'. Will then disregard the column with the remaining characters via the Select Tool.

Thanks!

KA