topic Blueprism in Product Forum

Blueprism

Lakshmi_Deepika — Mon, 28 Aug 2023 12:38:00 GMT

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
------------------------------

RE: Blueprism

DevendranVenkatesh — Mon, 28 Aug 2023 13:10:00 GMT

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
------------------------------

RE: Blueprism

NagarajanSundar — Mon, 28 Aug 2023 14:47:00 GMT

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
------------------------------