0005 in openoffice importing to zenno.

[awzse00]

Hello guys,

I have a problem reading from table a field with the value 0005, and open office it turns it into 5, if i change the value from numeric to text, open office shows it as 0005 but zenno won't read the table. Any tips ?

thanks

 

[VladZen]

0005 - is this some special numeric format in the table? Please attach template example and table file with such values in it.

 

[awzse00]

I've uploaded the temaplte, but it doesn;t let me upload the xcel. The table should look like this

HSN TSN
0005 AYU

A - HSN
B - TSN

 

[MorningRain]

As a temporary solution you can store such values with prefix like x0005 and then check for it and remove in code

 

[awzse00]

the problem is that in the table, some of them will have 000 some will have 00 some will have none.

 

[awzse00]

Figure it out finally. Thank you all. It can be closed

 

[awzse00]

Managed to get it working with txt files, that i load the HSN from a HSN.txt and TSN from a TSN.txt, and the rest of the details will load them from a open office. But an interesing thing to notice the 000 in excel and zenno.

thank you all