RE: using commas in a csv file output

2004-02-03 Thread Simon Adams



Thankyou 
Stuart,
This is the output 
I was looking for : "MD03,"
Cheers, 
Simon.Australia
-Original Message-From: Stuart Boydell 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, 3 February 2004 
17:57To: U2 Users Discussion ListSubject: RE: using commas 
in a csv file output

  FLAT.LINE:= quote(OCONV(PARTS.REC8,W,"MD03,"))
  
-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf 
Of Simon Adams
OK, I now 
get 10,000.00 but I would like to suppress the decimal places.

This is my 
line of code :
FLAT.LINE:='"':OCONV(PARTS.REC8,W,"MD3,"):'"'

Any further 
advise, most appreciated.


Cheers, Simon.Australia.

  **This 
  email message and any files transmitted with it are confidentialand   intended solely for the use of addressed recipient(s). If you have 
  received this email in error please notify the Spotless IS Support Centre 
  (61 3 9269 7555) immediately who will advise further action.This   footnote also confirms that this email message has been scannedfor the 
  presence of computer 
  viruses.**

*
This e-mail, including any attachments to it, may contain confidential and/or personal information.
If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action 
based on the information contained within it.

Please notify the sender immediately by return e-mail of the error and then delete the original e-mail.

The information contained within this e-mail may be solely the opinion of the sender and may not necessarily 
reflect the position, beliefs or opinions of Salmat on any issue.

This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems.

For more information, visit our website at  www.salmat.com.au.
*


-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


using commas in a csv file output

2004-02-02 Thread Simon Adams



How can I force a 
comma in an outputted csv file ?

I want to put 
commas in numbers eg: 10,000 but as the delimiter is a comma, 
it puts 10 in one column and then the 000 in the next 
column.
How can I OCONV 
the output but keeping the number together ?

Cheers, Simon.Australia.


*
This e-mail, including any attachments to it, may contain confidential and/or personal information.
If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action 
based on the information contained within it.

Please notify the sender immediately by return e-mail of the error and then delete the original e-mail.

The information contained within this e-mail may be solely the opinion of the sender and may not necessarily 
reflect the position, beliefs or opinions of Salmat on any issue.

This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems.

For more information, visit our website at  www.salmat.com.au.
*


___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users