We have a requirement to get the group for users, but the group which we get from rest api is
"10014113~DLV2000 Construction Crew"
We need to get the value after the character '~'.
we have written below inline preprocessor query, but this does not work.
Could you please let us know what to use to get this substring.
"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.USERNAME = CURRENTUSERS.USERNAME SET NEWUSERDATA.customproperty54 = substring(CURRENTUSERS.customproperty11,CHARINDEX('~',CURRENTUSERS.customproperty11) + LEN('~'), LEN(CURRENTUSERS.customproperty11))
Solved! Go to Solution.