Issue with Left trim

[Taki]

I am trying to left trim the file but is working for all except when doing profit where it trims the first 2 characters as well so I am left with "ofits". Appreciate help. Thanks

[Blake · Accepted solution]

Hi @Taki 

Try using replace([upd_column],"Curr-","") and replace([upd_column],"Prev-","") rather than trim left. The Trim function is trimming PR from profits. 

[Zas3NfkB]

@Taki you could also save yourself from needing to type a bunch of code and do a text to column tool with 2 columns and a deliminator on -. That way you can do the entire field at once