INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Remove bracketed data inc the brackets

Remove bracketed data inc the brackets

(OP)
I have a field containg random length names but with an abrebviation at the end in brackets. I want to just show the name

eg xxxxx (yy xx bb) show xxxx

xxxxx XXXXXXX YYY (aa bb) show xxxxx XXXXXXX YYY


I tried this for instance :

replace ({Divisions.LongName},"(Head Office UK)","")

BUT the problem is the abreviation can be anything and any length so I need the formula to be something generic to replace whatever is in the brackets with nothing , plus the brackets of course :>)

RE: Remove bracketed data inc the brackets

Left({table.field}, instr({table.field},”(“)-2)

-LB

RE: Remove bracketed data inc the brackets

PS. If you copy the formula into CR, retype the quotes, since my iPad is returning quotes that aren't recognized by CR.

-LB

RE: Remove bracketed data inc the brackets

(OP)
sorry this doesnt work at all. I just get an error msg when trying to save it

RE: Remove bracketed data inc the brackets

What is the error message?

-LB

RE: Remove bracketed data inc the brackets

Also, I did test this, and it worked perfectly here, so please post the exact formula that you used.

-LB

RE: Remove bracketed data inc the brackets

(OP)

filed formula -->
left({Divisions.LongName}, instr({Divisions.LongName},”(“)-2)

error msg -->

A number, currency amount, boolean, date, date-time or string is expected here

RE: Remove bracketed data inc the brackets

LB did say retype in Crystal formula. The double quotes look wrong.

,”(“)

Should be more like

,"(")

Ian

RE: Remove bracketed data inc the brackets

(OP)
Thanks Ian

It works now, thanks

I did see his comment but the font on here is so small I could not see an issue, when I pasted into word and expanded the font I could see the VERY subtle difference

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close