Pdf Extraction date and number and name

[Sudheer_Kumar_S]

9/22/22, 2:10 PM Web Portal PJK | Pencarian
Parameter =
NIK required
3171040102590004
Tempat Lahir.
Nama:
| AHMAD FAJARPRANA I
Xxxxxxx cxxxxxxx xxxx
Gahakskdkdk

I want date from first line and number below NIK required and name below Nama please help

[Anil_G (Anil Gorthi)]

@Sudheer_Kumar_S

Try this system.Text.RegularExpressions.Regex.Match(stringvar,"<Pattern>").Value

Pattern1 = ^\d{1,2}/\d{1,2}/\d{2}, \d{1,2}:\d{1,2} \w{2}

Pattern2 = (?<=NIK required\n+)\d*

Pattern3 = (?<=Nama:\n+\|).*

Replace pattern for each type in the given expression at top

Cheers

[Sudheer_Kumar_S]

Hi @Anil_G thanks for reply. Date is coming but NIK number and name are not coming. I have edited post pls check there is no space in between lines

[Anil_G (Anil Gorthi)]

@Sudheer_Kumar_S

Please try this expression with same pattern

system.Text.RegularExpressions.Regex.Match(stringvar,"<Pattern>",RegexOptions.MultiLine).Value

cheers

[Parvathy (PS Parvathy)]

Hi @Sudheer_Kumar_S

Date:

NIK Number:

Nama:

Hope it helps!!
Regards,

[Yoichi]

HI,

FYI, Another sample :
Can you try the following?

System.Text.RegularExpressions.Regex.Match(strPdf,"^\d+/\d+/\d+").Value

System.Text.RegularExpressions.Regex.Match(strPdf,"(?<=NIK required\r?\n)\d+").Value

System.Text.RegularExpressions.Regex.Match(strPdf,"(?<=Nama:\r?\n).*").Value

Sample20230530-6L.zip (2.4 KB)

Regards,

[Sudheer_Kumar_S]

@Sudheer_Kumar_S

NIK required
3171040102590004

NIK required
| 3171040102590004 |

When kept log it is coming like this but regex is not working on it… pls check and can you ignore pipe symbols in output… thank you
@Yoichi @Anil_G

[Yoichi]

HI,

Can you share your string as a file? We can write it to a file using WriteTextFile activity.

Regards,

[Sudheer_Kumar_S]

Hi… I made some changes to regex you’ve given it’s working but… one change required… can we ignore | these pipe symbols

9/22/22, 2:10 PM Web Portal PJK | Pencarian
Parameter =
NIK required
| 3171040102590004 |
Tempat Lahir.
Nama:
| AHMAD FAJARPRANA I
Xxxxxxx cxxxxxxx xxxx
Gahakskdkdk

[Yoichi]

Hi,

How about the following?

System.Text.RegularExpressions.Regex.Match(strPdf,"(?<=NIK required\r?\n\D*)\d+").Value

System.Text.RegularExpressions.Regex.Match(strPdf,"(?<=Nama:\r?\n\W*)[\w\s]+").Value

Regards,

[Sudheer_Kumar_S]

Thank you @Yoichi @Anil_G for your quick help and replies