Skip to main content
Nintex Community Menu Bar

get a data from excel

  • January 17, 2022
  • 6 replies
  • 20 views
  • Translate

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

Did this topic help you find an answer to your question?

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

Translate

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

Translate

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

 

Translate

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)

Translate

Hi

I am reaching out to you on your email.

Marlon

Translate

HI

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

i'm here...

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings