how to get the String after special character.

[Former Member]

hi.

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

[abhilash_kumar · Accepted solution]

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]

-Abhilash

[Former Member · Accepted solution]

hi.

i will check it...give me some time.