Claudine Are you leaving the output file open?
Buddy From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 4:50 PM To: rbase-l@googlegroups.com 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: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 2:29 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 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: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: Saturday, February 24, 2018 12:11 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 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: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Saturday, February 24, 2018 12:21 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 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: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Buddy Walker Sent: Friday, February 23, 2018 10:45 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 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: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Friday, February 23, 2018 10:55 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 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 -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.