Get specific character in text

sadiqbasha · September 5th, 2013, 09:20 AM

I have a below string

string = "C_123456789_1"

how to extract C_123456789 alone.

the character C and the number 123456789 may change...

Logically i want to extract the the characters left to the second underscore(_).

kindly help me

mhkay · September 5th, 2013, 09:25 AM

In pseudocode:

Code:

p1 = substring-before(in, '_')
p2 = substring-after(in, '_')
p3 = substring-before(p2, '_')
concat(p1, '_', p3)

sadiqbasha · September 6th, 2013, 08:45 AM

Youa re great!! thanks a lot .!!