Need to extract data from textfile

Help Studio
, ,
1

Hi

I need to extract “99864060” from attached text file.
please help me.
TextFile.txt (204.7 KB)

image
image1366×728 31.2 KB

2

Hi,

Is there any rule or fixed string to get your target string?

Regards,

3

its a fixed string. There is no rule.

4

Hello @shruthi_arali

Can you tell us more about the number?

  • Length?
  • Always at the end of line?
  • What is consistent around it?
5

Its a PO Number. It is displayed under PO Number. Length is constant.

image
image1366×768 64.5 KB

6

HI,

How about the following expression? This extract numeric characters which exists at the end of the next line of “PO NUMBER” (Because I guess it’s PO NUMBER)

image
image852×392 15.8 KB

System.Text.RegularExpressions.Regex.Match(strData,"(?<=PO NUMBER[\s\S]+?)\d+(?=\r?\n|$)").Value

Sample20230907-3L.zip (14.4 KB)

Regards,

1 Like
7

Thank you @Yoichi …:slight_smile:

1 Like
8

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