Crystal reports Description contains bracket

• Jul 4, 2023

• #2

dgillz

Instructor

Mar 2, 2001

10,052

US

replace(replace({YourField},"(",""),")","")

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

Upvote 0 Downvote

• Jul 5, 2023

• Thread starter
• #3

Kevin Mizzi

Technical User

Jul 4, 2023

6

MT

Hi dgillz

thanks for your reply.

what i need is if a description is Testing (6) i need to remove the description Testing and Showing only the (6) and if possible without brackets. so the result should be 6 only.

 

Upvote 0 Downvote

• Jul 5, 2023

• #4

pmax9999

Technical User

May 6, 2007

1,106

AU

Will the data always be exactly what you put above, or is that just an example? The following will ignore whatever string precedes the opening bracket, and return everything from that point but excluding the brackets themselves.

Code:

REPLACE(REPLACE(MID({Table.Field}, INSTR({Table.Field}, '(')), '(', ''), ')', '')

But if there are other patterns to the data it will not work. If the above code does not work you will need to explain all possible patterns.

Hope this helps.

Cheers
Pete.

 

Upvote 0 Downvote

• Jul 5, 2023

• Thread starter
• #5

Kevin Mizzi

Technical User

Jul 4, 2023

6

MT

hi Pete

thanks for your reply

i forgot to mentioned that the description is Testing (6) 451221 and i need to show only the 6 which are in the brackets - so i need to remove Testing () 451221

 

Upvote 0 Downvote

• Jul 5, 2023

• #6

pmax9999

Technical User

May 6, 2007

1,106

AU

The following code will return everything between the brackets.

Code:

Local numbervar start := INSTR({Table.Field}, '(');
Local numbervar end   := INSTR({Table.Field}, ')');
MID({Table.Field}, start + 1, (end - start - 1))

Cheers,
Pete

 

Upvote 0 Downvote

• Jul 5, 2023

• Thread starter
• #7

Kevin Mizzi

Technical User

Jul 4, 2023

6

MT

Hi Pete

you are super! many thanks

 

Upvote 0 Downvote

• Jul 5, 2023

• Thread starter
• #8

Kevin Mizzi

Technical User

Jul 4, 2023

6

MT

hi Pete,

if the description doesn't contains the ( Bracket in the description can i use "else" or "then" to showing the word "to fill" ? because i'm getting an error where the bracket is not available in the description.

thanks

 

Upvote 0 Downvote

• Jul 5, 2023

• #9

pmax9999

Technical User

May 6, 2007

1,106

AU

This is why you need to understand your data, and provide all the details at the outset.

Code:

Local numbervar start := INSTR({Table.Field}, '(');
Local numbervar end   := INSTR({Table.Field}, ')');

IF      start > 0
THEN    MID({Table.Field}, start + 1, (end - start - 1))
ELSE    {Table.Field}

This will return the original contents of {Table.Field} when no opening bracket exists, and assumes there will always be a closing bracket whenever an opening bracket exists. Depending on what you want to happen when there is no '(' you might need to change the ELSE result.

 

Upvote 0 Downvote

• Jul 5, 2023

• #10

dgillz

Instructor

Mar 2, 2001

10,052

US

Just for the record those are parentheses not brackets.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

Upvote 0 Downvote

• Jul 5, 2023

• #11

pmax9999

Technical User

May 6, 2007

1,106

AU

Just for the record, you're not helping.

 

Upvote 0 Downvote

• Jul 6, 2023

• Thread starter
• #12

Kevin Mizzi

Technical User

Jul 4, 2023

6

MT

thank you both now is working as i needed.

 

Upvote 0 Downvote