Extract the number fromaftercomment

Help
1

1716510480 Comment: 9497 6/1/2019 7/10/2019 $20.77 $0.00 $20.77
Total: $20.77

Hai i need to extract the 9497 number in after comment
could u please tell me the regex options

2

Use this

text.Substring(text.IndexOf("Comment: ")+"Comment: ".Length).Split(Environment.NewLine.ToCharArray)(0)

2 Likes
3

Hi @veera_g

Kindly try with this buddy
if the input string is like this
in_str = “1716510480 Comment: 9497 6/1/2019 7/10/2019 $20.77 $0.00 $20.77
Total: $20.77”

then the output will be
out_Str = Split(Split(in_str.Split(Environment.Newline.ToArray())(0),": “)(1).ToString.Trim,” ")(0).ToString.Trim

Cheers @veera_g

1 Like
4

@veera_g you can try also this buddy split(text.Split(environment.NewLine.ToArray(),stringsplitoptions.RemoveEmptyEntries)(0)," ")(2).ToString

1 Like
6

[quote=“veera_g, post:5, topic:132061”]
Its fine working for me i have another doubt suppose i need after the num like 1716510480 after 9497 means

1716510480 9497 6/1/2019 7/10/2019 $20.77 $0.00 $20.77
Comment:
[/quote]Its fine working for me i have another doubt suppose i need after the num like 1716510480 after 9497 means

1716510480 9497 6/1/2019 7/10/2019 $20.77 $0.00 $20.77
Comment:

1 Like
7

i didn’t get this buddy
kindly come again once
Cheers @veera_g

8

After the 1716510480

9

“1716510480 Comment: 9497 6/1/2019 7/10/2019 $20.77 $0.00 $20.77"
do you mean in the highlighted one in the above string as output

Cheers @veera_g

10

am waiting your replay

1 Like
11

is this needed @veera_g

12

text.Substring(text.IndexOf("1716510480 ")+"1716510480 ".Length).Split(Environment.NewLine.ToCharArray)(0)

13

s we needed and we need another if comment is present or not present we extract the 5 digit number

14

Any possible code to get 5 digit number or 4 digit number after the 1716510480

15

str.Substring(str.IndexOf(“1716510480”),5)

Try this to get 5 characters after that particular string

1 Like
16

s got it

Thanks for your quick help

17

:slight_smile:

18

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