String manipulation based on certain conditions

Help Studio
1

Hii,
I have a string like “bshs : lmno”
I should be able to extract “lmno”

Means whatever values are there after colon i want to extract it. spaces should ignore after colon

2

one of many options
grafik

YourStringVar.Split(":"c).Last().Trim

1 Like
3

Hi Tabbu,

One quick solution can be -

suppose your value is in variable StringText then -
StringText.Split(":"c)(1).Trim

Thanks

1 Like
4

Hi @Tabbu

Try this below expression

Split("bshs : lmno",":").Last

Split("bshs : lmno",":")(1)

image

Regards
Gokul

1 Like