jcrawford08
Technical User
to preface, running CR XI R1 in a SQL envirotnment...
I have a user who needs to track manual follow ups; she is prefacing a string field with a number (1-5) followed by an equal sign (=) and then some additional information.
I had planned on doing a split then on the string field at the equal sign and then converting it to a number, so that I can add it to another section that tracks automatic follow ups. But alas, the best laid plans go astray...
I get an error with the following line, indicating that the string is non-numeric...
tonumber (split({User.Comments},"=")[1])
I thought that in converting to a number, it would read the string as numeric, but apparently there's something I'm misunderstanding regarding its usage.
Any ideas or work-arounds to use?
Thanks!
Not in word only, but in deed also... 1Jn3:18
I have a user who needs to track manual follow ups; she is prefacing a string field with a number (1-5) followed by an equal sign (=) and then some additional information.
I had planned on doing a split then on the string field at the equal sign and then converting it to a number, so that I can add it to another section that tracks automatic follow ups. But alas, the best laid plans go astray...
I get an error with the following line, indicating that the string is non-numeric...
tonumber (split({User.Comments},"=")[1])
I thought that in converting to a number, it would read the string as numeric, but apparently there's something I'm misunderstanding regarding its usage.
Any ideas or work-arounds to use?
Thanks!
Not in word only, but in deed also... 1Jn3:18