I was wondering if anybody knew how to remove spaces from a field. I have this: |ESR^SED RATE ESR and I need to get it down to this: |ESR^SED RATE ESR.
I wasn’t sure if a I could do a trim and use ” ” for my character I want to trim on(that’s 2 spaces between the quotes).