10-21-2009 4:52 PM
Hi,
I have created a additional field in SQ02 called " Test", My question is what is the syntax for getting the left part of a string I.E
TESTING1234 i wish to get the first 7 chars i.E left(Field1,7) , but i get an error when I use this code, I have pressed F1 for help
but cannot see any help for Left, Right or Mid functions
Your Help would be much appreciated
Cheers
Dave
10-21-2009 4:57 PM
Hello,
You should use the name of the variable and between ( ) the number of characters you want (starts from the left).
In your case : VARIABLE(7)
In case you want 7 characters starting from the third character : VARIABLE+3(7).
Success.
Wim