Buddy, One (small) problem, the variables initialize just fine but only the last row/line writes to the file! I’ve tried OUTPUT vfilename APPEND and WRITE .vwritext to .vfilename. No left or right parens however…
Claudine From: [email protected] [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 2:29 PM To: [email protected] Subject: RE: [RBASE-L] - Formatting OUTPUT This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing> Feedback<http://aka.ms/SafetyTipsFeedback> Thanks Buddy! Learning exercise too, I don’t think I have ever used SPUT this way. Claudine From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Saturday, February 24, 2018 12:11 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - Formatting OUTPUT Claudine I think you are going to have to loop through the table. See attached file. I didn’t test it but I think it may give you a start. Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 12:21 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - Formatting OUTPUT Thanks Buddy. I thought my messages were being bounced. Here is my code. And YES setting EOFCHAR OFF takes care of that right arrow. Claudine -- OUTPUT .vfilename UNLOAD DATA FOR chrispreptbl USING + (CALLIT + (SFIL(' ',(50-(SLEN(CALLIT))))) & (CTXT(invdate)) + (SFIL(' ',2)) + (FORMAT(amount,'[>]999,999.00')) & MARK) + AS ASCII WHERE edate = .#DATE ORDER BY CARRIER,INVOICE OUTPUT SCREEN From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Friday, February 23, 2018 10:45 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - Formatting OUTPUT Claudine Are you doing an unload data from a table and all of the data is in one column. If so it will quote the text with single quote because of the space. The character that looks like a right arrow could be the EOFCHAR. Can you show the code you are using for output either ASCII or CSV or both. The Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Friday, February 23, 2018 10:55 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - Formatting OUTPUT Either I output as ASCII or CSV and I still get those extra quotes and return. Any idea how I can suppress those? TIA, Claudine [cid:[email protected]] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
