Remove extra characters from specific excel column as input form allows only limited character count

[loozea]

In my input excel file I have a column that has long names with many characters but application input form doesn’t allows to enter text more than 40 characters.
So as an input I only want to use name cell column value with maximum of 40 characters.

Is there any specific excel or any other acivity I can use to remove characters from excel ? Or while using the text as an input before entering into application form? Or there are any other ways to achieve it?

[asesor-rpa (Nestor Andres Martinez)]

String.Substring Method (System)

[nimin (nimzz)]

Hi @loozea,

I hope String.Substring(0,(Math.Min(40,String.Length))) will work for you.
You can use the below expression inside a ‘for each row’ activity to pass the column value to your application with a maximum length of 40.
row("Column").ToString.Substring(0,(Math.Min(40,row("Column").ToString.Length)))

Warm Regards,
Nimin

[loozea]

Hi @nimin ,

It’s working. Thankyou for help