Yes, I’m using your code so file is open until after the cursor loop. I’ll revisit tomorrow when my eyes are rested.
Thank you very much. Claudine Sent from my iPhone On Feb 24, 2018, at 7:03 PM, Buddy Walker <[email protected]<mailto:[email protected]>> wrote: Claudine Are you leaving the output file open? Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 4:50 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - Formatting OUTPUT 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]> [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 2:29 PM To: [email protected]<mailto:[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 <image001.png> -- 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]<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.
