I am unable to split the word"Standard PO created under the number 0000000001 Message no. 06017". in this sentence I need only"0000000001"

Learn Academy Feedback
1

Hello Everyone!.

In the above text I need only “0000000001” in the entire text. I also tried with substring. But I am getting like"0000000001 Message no. 06017" not exactly that I want. Kindly help me.

2

Hi @Abudhahir

Please, if you can! Share the entire string.

See, if this can help!

https://regex101.com/r/xaz6ID/1

2 Likes
3

Hi @Abudhahir,

Try this :

RequiredString = ((strs.Split(CType(“Message”, Char)).First).Split(CType(“number”, Char)).Last).Substring(5).Trim

I hope this works if the string contains “Message” and “number” always. I’m not good in regex but tried this :slight_smile: .

Let me know if it helps

4

Standard PO created under the number 0000000001
Message no. 06017.

The above is the entire string.

In this entire string, I need only “0000000001”

5

@Abudhahir

The regex code i gave you should do it!

1 Like
6

Hi @Abudhahir
Please see this sample xaml file about Regex: Sequence.xaml (4.7 KB)

1 Like
7

Hello Brian
The sequence.xaml missing some activity. I am unable to view your bot.

8

index string.xaml (4.6 KB)
plz have a look at this. plz let me know if any thing goes wrong.

10

its working fine. Thanks Venkatmalla

11

@Abudhahir mark it as solution,so that it would be useful to others also.thanks

13

Sure.

14

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