read text file from excel

bangswit

hi all, i have document no = 12345
but in excel buffer it is 12,345
how to make it become 12345
my code is like this (failed)

EBDoc.RESET;
EBDoc.SETRANGE(EBDoc."Row No.",RowNo);
EBDoc.SETRANGE(EBDoc."Column No.",11);
IF EBDoc.FIND('-') THEN
PL."Document No.":=FORMAT(EBDoc."Cell Value as Text");
PL.VALIDATE(PL."Document No.");

Hanen

Hi,

you should read the cell value and eliminate the "," SOMETHING LIKE SUBSTR

rhpnt

Check the cell format of your Excell sheet (it should be text) and the value of the field.

bangswit

rhpnt wrote:

Check the cell format of your Excell sheet (it should be text) and the value of the field.

yes
that's right
i chance the excel file and it works
thanks