Blueprism

[Lakshmi_Deepika]

Hello Everyone

This is regarding issue in Excel

How to add 1 at the end of the number so the length becomes 10 in Excel via blueprism logic

Eg: Existing number in Excel: 123456789

After adding one at the end: 1234567891

Pls advise on this how to perform 

------------------------------
Lakshmi Deepika Mudumba
------------------------------

[DevendranVenkatesh]

HI,

Use below logic for example,

Excel data for example as per your request and modify the logic as per your file if its required.

BP logic

------------------------------
Best Regards,
Devendran Venkatesh
RPA - Technical Architect |
Riyadh 11413, Kingdom of Saudi Arabia
Phone. +966-556784162
------------------------------

[NagarajanSundar]

Hi, as mentioned in the below thread, you can use concat for adding '1' at last. otherwise

you can write a simple excel formula in your configuration '=if(len(a1)=10,a1&"1","")'  file and place this formula at last column and drag till end of the row which helps you to see the data in a quick way. this will be helpful when you have more data in a excel cell.

------------------------------
Nagarajan Sundararajan
------------------------------