Crystal reports Description contains bracket
Crystal reports Description contains bracket
(OP)
hello,
i need to show a part of a description, if the description is Testing (6) (with bracket) i need to show only the 6 in the bracket. any idea please?
i need to show a part of a description, if the description is Testing (6) (with bracket) i need to show only the 6 in the bracket. any idea please?
RE: Crystal reports Description contains bracket
Macola Software Veteran and SAP Business One Consultant on Training Wheels
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Crystal reports Description contains bracket
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.
RE: Crystal reports Description contains bracket
CODE
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.
RE: Crystal reports Description contains bracket
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
RE: Crystal reports Description contains bracket
CODE
Cheers,
Pete
RE: Crystal reports Description contains bracket
you are super! many thanks
RE: Crystal reports Description contains bracket
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
RE: Crystal reports Description contains bracket
CODE
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.
RE: Crystal reports Description contains bracket
Macola Software Veteran and SAP Business One Consultant on Training Wheels
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Crystal reports Description contains bracket
RE: Crystal reports Description contains bracket