I want to take the first 3 character from the column A and put it in a new column

[Rawan_Ghurab]

I want to take the first 3 character from the column A and put it in a new column with header “MainLocation”

I tried But I did not work for me , how can I do it

[Catfish1115]

Assign

[arjunshenoy]

Hi @Rawan_Ghurab

You can iterate through each ‘currentRow’ in the data table using ‘For Each Row in Data Table’ activity & fetch the first 3 characters using like this:

firstThreeChars = currentRow(“Location”).ToString.Trim.Substring(0,3)

Here, firstThreeChars is a variable of type String.

Hope this helps,
Best Regards.