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]

[image] andrew.haworth: I am really sorry Peter but I am just not getting this! I am quite new to RPA 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 stri…

For each row - read only last 5 numeric characters

Help Studio

Sanjit_Pal (Sanjit Pal) August 30, 2022, 11:25am 2

Hey @andrew.haworth,

Use the below method

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

Thanks,
Sanjit

Topic		Replies	Views
Can someone guide me how to select only 3 character in datatable Robot question	2	430	May 30, 2023
How to get last n characters from a row value to other column StudioX studiox , question	6	314	October 6, 2023
End of the line Help	5	5504	August 15, 2017
Excel read cell Help	9	1930	October 29, 2018
Get (partially) ride of Text in datatable Help	7	1050	January 29, 2019

For each row - read only last 5 numeric characters

Related topics