Storing table to text files

[shannoypaul]

MyTable:

LOAD

Country&'|'&Month&'|'&Val as Fulldata

FROM

(ooxml, embedded labels, table is Sheet1);

STORE MyTable INTO MyCSVFile.csv (txt);

The field "Val" has decimal values till 8. But when I store it to "MyCSVFile.csv" it takes only till 2 decimal places.

Please let me know how to maintain the same formatting.

TIA,

Shannoy

[awhitfield]

Hi Shannoy,

can you upload your xlsx please?

Andy

[Peter_Cammaert]

In a textual keyfield, instead of Val use Num(Val, FormatString') where you replace FormatString with a proper format e.g. '#0.00000000' (assuming you use US decimal separators)

Peter

[jonathandienst]

Perhaps

LOAD

Country&'|'&Month&'|'&Text(Val) as Fulldata

FROM