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

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?

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.

Warm Regards,

Hi @nimin ,

It’s working. Thankyou for help

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.