For each row - read only last 5 numeric characters

Help Studio
, ,
1

I am working with For each row in Studio to read ID numbers from a CSV file. I wish to configure my robot further to only read the last 5 numeric characters from the right-hand side of the number in my data table “input”. The last character is an alphanumeric character in all cases.

image
image573×613 16.3 KB

2

Hey @andrew.haworth,

Use the below method

row("name").ToString.Substring(row("name").ToString.Length-3)

Thanks,
Sanjit

3

Thanks this is now working well!

4

Great To hear that it’s working fine for you.

Could you please mark it as a solution so that thread should get closed and helpful for others as well.

5

Thanks Sanjit, I have updated the solution check flag. Can I ask if I wished to read the last 5 characters and ignore the alphanumeric character at the very end of the number. What is the syntax?

6

Are you looking for this?
grafik

7

Thanks Peter,

Can you explain to me how I append this to my existing (working code)

row(“IDnumber”).ToString.Substring(row(“IDnumber”).ToString.Length-5)

at the moment this reads the last 5 characters. I wish to ignore the last character only

8

we use a regex.match as the following:
grafik

System.text.RegularExpressions.Regex.Match(yourStringVar,"(\d{5})(?=\D*?$)").Value

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

9

Hey Peter,

When I add that Test to my UI Path activity I obtain the following error:

Option Strict On disallows implicit conversions from ‘Object’ to ‘String’

Can you advise?

A

10

check your involved datatypes

feel free to share a snap and more details with us

11

so my data item would be in the format “XXXXXXXY”

where X= numeric
and Y = alphanumeric

it is the “Y” I wish to remove ignore

12

What if I just counted from the left?

A

13

image
image1041×593 42.4 KB

Here is my activity. The PID should be read into my data table without the alphanumeric character at the end. This character is randomly generated.

My problem is to find the right syntax to read only 7 characters in combination with a For each row in a data table activity

Best regards

A

14

grafik

its about patterns

grafik
(\d{5,})(?=\D*?$)

15

Sorry do I just write the Regex command in the Messagebox?

ie

image
image1257×525 35.7 KB

16

was demonstrated above

so will use it there, where you need/want to work with value.

17

I am really sorry Peter but I am just not getting this! I am quite new to RPA and would really like to make this work for my workflow:

image
image1424×567 33.5 KB

Each time I try to utilise the System.text.Regular Expressions command I obtain a validation error.
Would you have time If I was to share my test project with you?

Andrew

18

no problem, but ensure that the relevant things are also shared with us (e.g. implementations, validation messages in complete)

row(“PID”) will return a reult of datatype: Object, but a string is needed for the regex input

As usually use row(“PID”).toString for the Regex input

19

Ok thanks Peter, I have attached the project folder. The robot will read a sample file located in the samples directory in the project folder. I also include a screenshot with my requirements (in case 'i was not good at explaining previously?!)
Really appreciate the support!

image
image709×651 39.5 KB

For Each Row.zip (4.2 KB)

Many thanks

A

20

Peter,

I read your last message again and here you go! It works!

image
image939×636 20.1 KB

Thanks

A