Delete first 3 Letters in an entire column

[Lamina_Zafrullah]

Hello Bosses

Please I have a problem. I have a particular cell on a sheet that contains letters and numbers.

I want to delete the first three letters in each cell so that i will be left with only numbers for the entire column.

like I have something like this

ABC001234
ABC009898879
ABC9854345
ABC076554
ABC2340987
ABC47633
ABC56800008

I want to delete the first three letters in the entire colunm

Thank you

[michael.zura (GuardiansFan)]

@Lamina_Zafrullah
Hello
You can use YourStrings.Substring(3) as long as they all need the first 3 letters removed.

Regards

[Lamina_Zafrullah]

Thank you @michael.zura I am new on Ui Path, can you please walk me through the full process step by step? Thank you

[michael.zura (GuardiansFan)]

@Lamina_Zafrullah
Something like this, not sure if you have column headers but:

Read Range of Excel into Data Table

Loop over Data Table column that you want to alter
InitialString = CurrentRow(“Value”).ToString
CurrentRow.Item(“Values”) = InitialString.Substring(3)

Then Write Range Data Table back to Excel with updated data

Regards

[mohiniganesh15]

hi @Lamina_Zafrullah
If there is only one charcter then you can use

row(ColumnIndex).ToString.Replace(“'”,String.Empty)

Mark as solution if it is useful let others take advantage…

regards
Mohini Sonule
Happy Automation !!!