String Manipulation having some condition

Hii,

I have a string like this formate
“xyzs :” and “xyzs : 87653wd”

I Wanted to check after the colon is any value are there or not.
If any value are there then need to extract that value
if not present then i need to move to the next column

Pls help ASAP

@Doonline

Use Regex for this as below

image

Once you done that you can use IF condition as below

YourVariable <> " " Or YourVariable <> “”

Hope this may help you

Thanks

Here is another answer you may find helpful.

image

Kind Regards

in which activity should i use it please show

getting erroe in this pattern

@Doonline

Check below for your reference

Hope this will help you

Thanks

I Want to Extract the value which is after colon
Through this pattern i m getting empty value

if string is like this “xyzs : 87653wd”
then i should be able to extract 87653wd

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.