Jump to content
Sign in to follow this  
Jalz

Trim spaces only in brackets

Recommended Posts

Hello All,

Ive got the data in my records just about cleansed. A have one field in particular with lets say the following details.

ENG_1R (AEB )

MAT_3D (AJK)

LAT_2Y (AJK AEB )

IT_2I (UAE )

I would like to remove the space before the bracket ends so record 1,3 and 4 would have the endings (AEB),(AJK AEB) and (UAE).

Ive created a looping script with the TrimALL command but that removes all the spaces. Anyone have an idea of just removing the spaces in the brackets. Thanking all of you guys in advance.

Share this post


Link to post
Share on other sites

Why dont you just keep it to something simple and use:

Substitute ( field; " )"; ")" )

Share this post


Link to post
Share on other sites

Thanks Mr Vodka,

I'll try that...now why didn't I think of that!. Ive already got a substitute in that field doing some cleansing - and I thought, I can always add another "[]" with your code!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.