How to Display number with spec format

Hi,

I have getting table extract date one of number is “3 10294838” , we have some space coming. but I need output after space number start and end. Ex of output : 10294838

I don’t want to 3 space number.

How to achieve this , any one help please.

Thanks,
Rama

Give a try at:
grafik

Assign activity
strValue =
System.Text.RegularExpressions.Regex.Match(yourStringVar.Trim,"\d+$").Value

@rama_krishna_Rao,

If your input will be constant to have space, Try this approach.

stroutput=strInput.Split(" "c)(1).Trim

Thanks,
Ashok :slightly_smiling_face:

1 Like

Hi @rama_krishna_Rao

You can try the below syntax:

Input = "3 10294838"
Output = Input.Split(" "c).Last()

Regards

Thanks a lot Peter,
It’s working your code. I have using below code

System.Text.RegularExpressions.Regex.Match(CurrentRow(0).ToString,“\d+$”).Value

Thanks,
Rama

Thanks ashok,

It’s working

stroutput=CurrentRow(0).ToString. Split(" "c)(1).Trim

Thanks,
Rama

1 Like

Thanks Varunraj,

IT’s working your code too.

Output = CurrentRow(0).ToString.Split(" "c).Last()

Thanks,
Rama

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