Skip to Content

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

how to get the String after special character.


i need a small information.

the below word i am having in my database.

what i need is after ~ i need to get the string...

ED 12.36% ~ VAT 5% ~ MH

i used

Split({OSTC.Name}, "~")[1]

but i am getting

ED 12.36%  before one

but i need after ~ how can i get the value...

Former Member

Hi Srini,

If you need everything after the first "~", use:

Mid({database_field}, Instr({database_field}, "~"))

If you need just 'Vat 5%', use:

Split({OSTC.Name}, "~")[2]


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