on 12-19-2013 8:47 PM
Dear all,
I've requirement to check if the first two characters of the input are equal to "XM" then remove the first two characters from the input string and only map the rest of the string to a target field.
Please note that the input string does not have a fixed length. So the standard substring is not feasible to be used here.
Let me know if there is a better way to handle it without going to a UDF.
regards,
Younus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can check for the indexOf XM in the string and remove the value from the first index only.
Ambrish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.