RE: [RBASE-L] - Text file that retains trailing blank space

ames W. Kim, CPA, MBA Sent: February-21-18 6:32 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Text file that retains trailing blank space Smart idea.  It's a kind of paradigm shift to create the entire file including CR/LF in a VARCHAR variable. I will run some simulations to se

Re: [RBASE-L] - Text file that retains trailing blank space

ase-l@googlegroups.com Subject: RE: [RBASE-L] - Text file that retains trailing blank space Another approach is to put the data into a varchar variable and then write the variable to a file. SET V vDataFile VARCHAR=NULL SET V vLine TEXT=NULL . . . SET V vLine= SET V vDataFile=(.vDataFile+.vLine+CH

RE: [RBASE-L] - Text file that retains trailing blank space

:58 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Text file that retains trailing blank space Another approach is to put the data into a varchar variable and then write the variable to a file. SET V vDataFile VARCHAR=NULL SET V vLine TEXT=NULL . . . SET V vLine= SET V vDataFile

RE: [RBASE-L] - Text file that retains trailing blank space

1:25 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Text file that retains trailing blank space Thank you Stephen and others for the suggestions.  Most of systems I work with does not allow extended ASCII characters, so CHAR(160) would not work. I have been submitting formatted text files

Re: [RBASE-L] - Text file that retains trailing blank space

James, :) As mentioned in my original reply, that's the same character (CHAR(00)) I use for all my government and financial applications that deal with J/L entries, etc., where "trailing blank spaces" are required. Now you all know the secret of preserving "trailing blank spaces" for R:BASE

Re: [RBASE-L] - Text file that retains trailing blank space

Razzak, Just tried a test upload with over thousand entries.  CHAR(00) worked like a charm.  You R:ock! Thanks, James On 2/20/2018 1:39 PM, A. Razzak Memon wrote: James, When I saw your request for help, I knew exactly what you were looking for, thus my response with all details along with

Re: [RBASE-L] - Text file that retains trailing blank space

James, When I saw your request for help, I knew exactly what you were looking for, thus my response with all details along with a sample text file. Yes, my R:Crystal Ball was working . Have fun, and feel free to reach out to me if you have any questions. Very Best R:egards, Razzak At 01:2

Re: [RBASE-L] - Text file that retains trailing blank space

: [RBASE-L] - Text file that retains trailing blank space Thank you Stephen and others for the suggestions. Most of systems I work with does not allow extended ASCII characters, so CHAR(160) would not work. I have been submitting formatted text files to various federal and state authorities for

Re: [RBASE-L] - Text file that retains trailing blank space

Thank you Stephen and others for the suggestions.  Most of systems I work with does not allow extended ASCII characters, so CHAR(160) would not work. I have been submitting formatted text files to various federal and state authorities for years.  Some systems, such as EFTPS, are tolerant and

RE: [RBASE-L] - Text file that retains trailing blank space

Hi James, Can you insert CHAR(160) as the 512th character? This will keep the preceding spaces and will show up as a blank. I don't know though whether the program that takes the file as input will tolerate that. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251

RE: [RBASE-L] - Text file that retains trailing blank space

Personal I am using reports for this kind of functionality. There is an option Print to Text File and there you are able to create complex TXT files and so on. Tony -Oorspronkelijk bericht- Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens James W. Kim, CPA, MBA Ve

RE: [RBASE-L] - Text file that retains trailing blank space

nt: Monday, February 19, 2018 7:07 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Text file that retains trailing blank space James, Funny you should ask ... One of my financial and tax collection agency clients was required to submit the delinquent tax collection file for their GL pac

RE: [RBASE-L] - Text file that retains trailing blank space

James I have a file that contains the use of SFIL and SPUT. I used this to provide a class listing to a health insurance company. It's about 11 years old but I think it should still work. Buddy -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Be

Re: [RBASE-L] - Text file that retains trailing blank space

James, Funny you should ask ... One of my financial and tax collection agency clients was required to submit the delinquent tax collection file for their GL package that required pretty much the same file format that you are required to use on your end. In addition to using the SFIL and SPUT