Extract text from Text file using Substring

[Pavan_Srikar]

Hi All,

I am trying to do PDF Data extraction for some reasons with PDF I am not able to extract PDF correct so I extracted the desired text to the Text file from there I need to read the text and extract some values (around 5-10 )and assign each of them to variables.

How to approach this scenario? Using string manipulation or substring can anyone help with an example?

Sample data in the file looks like below
Name: Mirta Rodriguez
Address: 9 FLORENTIA ST
GLENFIELD NSW2167
ABN: 79910XXX785

[shaikmdrafi (shaik mahammad raphi)]

Hi

you can use regex to achieve this , please refer below link

Regex Expression with different format of string

Hi Team, I need to get specific word from lines of mail body. Here, I am able to check every line from body of mail,but i need to get exact word from string.Kindly help me. case 1: How to get Lavanya from the string User name - Lavanya case : 2 How to get Bindu from the string User Id : Bindu case :3 How to get Kiran from the string Vdi Id “Kiran” case: 4 How to get Saikumar from the string Please change password user name : Saikumar and Let me Known Please change password user name …

Thanks…

[Pradeep_Shiv]

you can use Matches activity

To Extract Name (?<=Name:).*
To Extract Address (?<=Address:)(.|\n)*(?=\n)
To Extract ABN (?<=ABN:).*

Cheers

[Pavan_Srikar]

Hi,
Thanks for the reply

I tried using the above to extract the values from the textile but I am getting null values.(Tried writing it to file ) and got the Object reference not set to an instance of an object.Null exception error

Tried using the Regex tester and saw it shows zero matches.

Am I missing anything here

[Pradeep_Shiv]

It’s matching right?
What’s the issue here?
Check for every Value if it’s matching or not.

Cheers

[Pavan_Srikar]

Sorry, My bad now cleared It matched.

Once this value is assigned to the collection variable from there If I want to assign to the variable I need to use foreach and assign to each variable right ?

Ex:- Name = CollectedData(0).ToString

Is this the correct approach

[Pradeep_Shiv]

Correct,
Cheers
Happy Learning
@Pavan_Srikar

[Pavan_Srikar]

@Pradeep_Shiv Thanks for the ton for the above Regex samples, understood it quickly and tried using it for the rest of my fields and all worked fine except a few.

[Pradeep_Shiv]

Great,
Let me know, if you still face any issues

[Pavan_Srikar]

Sure, one issue my text file has values that are a combination of two variables. VarA + VarB

My file looks like something below.

Here I am trying to get a driver’s license, but It has a continuation of one more header which is the start of the second variable value .

Name: Mirta Rodriguez
Address: 9 FLORENTIA ST
GLENFIELD NSW2167
ABN: 79910196785
Mobile No: 0413406671
Personal Email: mrcoaching26@gmail.com
Date of Birth: 16/10/1962
Driver’s Licence: 3184dsAccount No: 13287726
Introducing Dealer: Peter WarTen Toyota
Type: Toyota Access Business Vehicle Loan
Payment Required: $1,245.50
Contract Inception Date: 24 December 2018
Date Last Paid: 1 July 2020 Amount Last Paid: $410.25
Next Due Date: 22 October 2020 Next Payment Amount: $410.25
Arrears F/Fee Next Due: Arrears F/Fee Amount: $25.00
Instructions Issued Before?: No
Mortgaged Vehicle: 2018 TOYOTA YARIS
Colour: WHITE
Rego No: DZW63Q
Engine No: 2NZ8751771
VIN: JTDKW3D3801001503
Repo Allowed: Yes
Payout Amount: $17,722.06, available to 1 October 2020
Default Notice Dated: 7 August 2020
Expired On: 10 September 2020
Amount Due on Notice: $785.25.

any way while combining my second variable it will create in new line instead?

Thanks, Sorry for the long post.

[Pradeep_Shiv]

Hi @Pavan_Srikar,

I hope this helps

(?<=Driver’s Licence:).*(?=Account)

[Pavan_Srikar]

Thanks for the help most of my work is done with the above example.

Once again thanks for the help

Great learning and understanding today.

[Pradeep_Shiv]

Cheers
Happy Learning
@Pavan_Srikar

[Pavan_Srikar]

Hi @Pradeep_Shiv

Sorry to post this here

When I am trying to Set text into a column in one job portal .instead of variable name if I give hardcode values it is not giving any error.

If I Give a variable name I am getting the below error.

Source: Name (Name) (It is a variable name that has a value assigned from matches activity)

Message: Error HRESULT E_FAIL has been returned from a call to a COM component.

Exception Type: UiPath.Core.ElementOperationException

RemoteException wrapping UiPath.Core.ElementOperationException: Error HRESULT E_FAIL has been returned from a call to a COM component. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Error HRESULT E_FAIL has been returned from a call to a COM component.
at UiPath.UiNodeClass.Set(String bstrAttr, Object vValue)
at UiPath.Core.UiElement.Set(String attribute, Object value)
— End of inner exception stack trace —

Yesterday did the same code and got no errors ,this one was coming in the newly created code.

[Pradeep_Shiv]

Can you try using Type Into?
This is because of Browser issue or you can try Re-Installing Extension and try in IE or Edge

[Pavan_Srikar]

Thanks,
Will try using Type Into.
Currently using the IE browser only.

[Pradeep_Shiv]

Check with Chrome,

[Pavan_Srikar]

Hi @Pradeep_Shiv

Can you help on below extraction in for regex the below string I am trying to extract in 3 different variables .

Mortgaged Vehicle: 2018 TOYOTA YARIS
Mortgaged Vehicle: 0000 ABCDEF GHIJKL

I tried and extracted the 2018 but for rest two I am unable to fetch

I used (?<=Mortgaged Vehicle:\s).[0-9]* for 2018 it was fine

Thank you

[prasath17 (Guru)]

hi @Pavan_Srikar …Here you go…

Variable 1= YourRegexvariable0).groups(1).tostring
Variable 2= YourRegexvariable0).groups(2).tostring
Variable 3= YourRegexvariable0).groups(3).tostring

Please check this post where you find the sample xaml similar to yours to handle the groups…

How to split address

hi @T_Y_Raju - As i mentioned above Refer this post about Regex… Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more… To get to know about Regex, please spend 30 mins and go through this video

[Pradeep_Shiv]

@Pavan_Srikar

(?<=Mortgaged Vehicle:\s).[0-9]*

(?<=Mortgaged Vehicle:\s).*