Import from Excel - Numeric into Code (Thousand Separator)

Business Central/NAV Developers Forum
1

Hello

I try to import Excel Data to a table. I am using Excel Buffer.

I need to put into a code field the content of a cell wich is numeric but into NAV the field as got a separator that i don’t want ex 50’274 instead of 50274.

Can you help me to solve this problem ?

Thanks in advance for your help

SG

Code exemple : EmpPiv.VALIDATE(“No.”,ExcelBuffer.“Cell Value as Text”);

2

Hi SG,

EmpPiv.VALIDATE(“No.”,DELCHR(ExcelBuffer.“Cell Value as Text”,’=’,’’’’));

Will do the trick i think.

3

Hello Alexander.

Thank your for your help.

It works

SG