Split but using regular expressions

Please I have a lot of pdf files with some data and I need to get the information. I know how to use the split method but I want to use regular expressions to solve it. This is what the file looks like. Would appreciate regex solution. Pls help. Thanks

image

Hi @gregoryoffodum

Check with the below Regex thread by @Steven_McKeering !

It has a clear explanation.

Regards

1 Like

Hi @gregoryoffodum

Could you please confirm which information did you need from this file.

Thanks.

Issue Date: 2021-09-01
Receipt No: 630978319414
Received From: APPLE
Beneficiary Pin: 02491803-0701
Payer: GREGORY

The bold fields. Thanks.

Hi @gregoryoffodum

Check with the below expression!

(?<=: ).*

Regards

Hi @gregoryoffodum

You can try with below Regex Expression

(?<=:\s{2}).*

Here {2} is the count of space as per the requirement you can change the count.

Regards
Gokul

1 Like