Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

splitting a string

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..

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question