1 of 1 people found this helpful
So most likely you are running live against a datasource (so not using a TDE)...in which case not all datasources support all functions. So you can either extract to a TDE, and use SPLIT or...
everything should support the "simple" string manipulations of LEFT, RIGHT, MID and LEN
Hope that does the trick, but let me know if not
Thanks for getting back to me so quickly.
I extracted to a TDE and was able to use SPLIT.