import csv decimal point error

P

pbd

New Member
At the mo we wanna import a csv dump with Progresstalk. The import works fine but a digit of 1.00000 (real value = 1) is imported as 100000.

Does ProgressTalk has a setting to change the decimal point sign? In case of not I can write a conversion program to change the comma-separated values into ';' and thereafter I change the . into , but I need to make sure that Progresstalk is able to change the cumma-separator.
 
Cannot talk about ProgressTalk's export & import capabilites :awink:.

You cannot talk about the Progress/OpenEdge version you are using :rolleyes:.

But, Progress is something I can talk about:

  • You can change the export delimiter in adding the DELIMITER option to the export statement.
  • The decimal point an thousand seperator are determined by either the -E setting (European number format) or -numsep and -numdec startup parameters of the Progress session. If you do not specify them the defaults from the $DLC/startup.pf ( %DLC% on Windows respectively ... ) are taken. This applies to each input and output operation!
  • Speaking of which, you should also be aware that there are similar settings for dates ( date format and century setting, -d and -yy respectively ) which might be of interest to you.
HTH, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top