Skip to Content
avatar image
Former Member

how to get the String after special character.

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 22, 2014 at 01:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded