Best logic to remove part of a string from a field?

Question

Hi All,

I have a list of securities in my dataset, however, the system that generates this report sometimes includes the exchange name in the security id. so every month I find a few fields in my data set that are Security ID & Exchange name concatenated into one field. What would be the best way to identify and remove? Would it be through the find and replace tool? Or would a formula like IF contains or something be better suited?

Thank you!

Raj · Answer

@CDIns 
two ways for achieving this is added
mark done if solved.

3157.yxmd

cpet13 · Answer

@CDIns a formula like this should do the trick LEFT([Field],FindString([Field], "."))

CDIns · Answer

@Raj Hi thank you for the reply. Attached is the output and what I'd like to change the ID to. The IDs vary in length but appear to always be at the end of the string not in the middle.  Any pointers would be appreciated. Thank you!

Alteryx Example.xlsx