Re: Products to convert SpoolFiles/Reports to .csv ?

I hear this requirement all the time and my SPLTOOL software will do
similar to this, an allow you to also remove standard headings. This
way when you open the text file in Excel, etc you can tell it to use
the columns (blank spaces) as the separators. And it won't get
confused if the headings are in the file.

Now, on the other hand I personally don't like the idea of converting
a spooled file to csv (or another form of data). Why? Well, it's a
picture of the data, and if you have the actual data available it's
much easier and more reliable, I think, to use a program or even
query/SQL to create a temporary file, convert that to CSV and go from
there.

But, I do hear this request often and normally this is my response. :)

Brad
www.bvstools.com

On Wed, Jun 20, 2012 at 10:53 AM, Paul Nelson <nelsonp@xxxxxxxxxxxxx> wrote:

It's been a while, but the STMF parameter can probably handle it. ESEND
definitely can produce a *TEXT file that you could name with a .csv
extension. Then, you'd end up with a one field file.

It sounds bizarre, though, that the requirement is for a .csv file type. One
would have to assure there would be no commas in the data, wouldn't one?

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob P. Roche
Sent: Wednesday, June 20, 2012 10:44 AM
To: Midrange Systems Technical Discussion
Subject: RE: Products to convert SpoolFiles/Reports to .csv ?

I don't think ESEND converts reports to .csv only files or views. Reports
have a few formats they can be converted to like .pdf, or .rtf,. but since
there are no defined fields in a report, It won't convert to .csv




From:
John Rusling <jrusling@xxxxxxxxxxxxxxxxxxx>
To:
"midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>,
Date:
06/20/2012 10:39 AM
Subject:
RE: Products to convert SpoolFiles/Reports to .csv ?
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



What is the Help Systems product that does this?
We have Robot, so I just thought I'd ask, in case it's something I could
utilize.
John B

Both RJS and Help Systems have products with this capability.
Paul Nelson

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.