get a data from excel

  • 17 January 2022
  • 6 replies
  • 18 views

Hi Im using the function copy from excel to get some data

and for some reason when it give me the data - it deletes the last 2 chars.

for example:

I have the number: 1122334455667788

and when I extract it from the excel it will show me only: 11223344556677

as u can see the 88 is not exist...


6 replies

Hi Daniel. Did you try formatting the field to a number and then set the copy from excel command to "formatted text"?

Marlon

the field is a text (because thats how I'm getting it)

and I tried now "formatted text" and still the same result

by the way - no matter how many chars in the cell it will always give it without the last two

I tested it - no issues. please send us a screenshot

 

as you can see in the excel file in row A20 the full number is 445566778899 and in the show message it shows only 4455667788 (the 99 is missing)

and also

All the variables in that command are hardcoded

But I need this to work with regular variables (it didn't work as well with the regular vars)

Hi

I am reaching out to you on your email.

Marlon

HI

I saw that u schedualed a meeting on Zoom for 13:00

i'm here...

Reply