×
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!
  • Students Click Here

*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.

Students Click Here

Jobs

Remove bracketed data inc the brackets

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!

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