on 01-11-2015 10:50 AM
Dear all,
I have to split a string on four parts, how can i use it. 401040302\PCA\CA-PR-E008-14\1234 i want to split this into four parts based on delimiter.
1. 401040302
2.PCA
3. CA-PR-E008-14
4.1234
please let me know the formula..
Hi Akram,
The formula to show the first part of the string would be:
Split({Database_field}, "\")[1]
To show the second part, it would be:
Split({Database_field}, "\")[2]
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Both the issues indicate that the string is inconsistent!
First issue indicates that it couldn't find the "\" delimiter in the string.
The second issue indicates that the index you specified after the 'split' function is too much. e.g:
String = SAP\Crystal\Reports
and your formula = split({string}, "\")[4]
The string can only be split into three parts however the index specified above is 4 - hence the error.
-Abhilash
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.