If you wanna extract the value inbetween the ( ), you can use this calculation where field::value is the field of where you have the customer name and customer number in the format The ABC Company (456789).
@text = field::value;
@start = Position ( @text; "("; 1; 1) + 1;
@end = Position ( @text; ")"; 1; 1) - @start
Middle ( @text; @start; @end )
You could also use:
Filter ( RightWords ( Field::value ; 1 ) ; 9876543210 )
Thanks so much both of you for your kind responses. I used to be an okay programmer.. but now I am a bit of a hack.
I can make the system do what I need, but some things I don't understand. Very nice of you to help me out.
I tried Joakim's response, but I don't get anything as a result. Replacing the field::value with my field name "Customer".
I also tried Phil's method. I get a 'can't find table error'.
All of this is because I know enough to be dangerous. If possible to expand your answers to include weak programmer esque.. ?!
Thanks so much!!
You may need the name of the table, two colons and then the name of your field unless this is in a field defined in the same table. You can most easily add the field with correct syntax by finding the field in the list of fields in the specify calculation dialog and double clicking it to add it to your calculation.
Really want to thank both of you. BOTH worked perfectly. Once, I got my head out of...
THANKS SO MUCH! A fantastic resource!