Re: Creating tab delimited files

On Feb 22, 11:36 am, "Pete Dashwood"
<dashw...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Yes, as usual, Howard, you make good sense.

It is pretty trivial to create XML from a COBOL program (assuming you can't
simply plug in an existing XML component as you probably would in an OO
environment). There has been some discussion on this in the "Bridging the
Gap" topic, where both Richard and I have advocated using a a templated
approach for XML generation.

Guess how I output CSV files

# template acreport.file for writing file
#
# ----------------------------------------------------------
*CSV
*ADDCR
:header
Content-Type: application/csv; charset=ISO-8859-1;
Content-Disposition: attachment; filename="<!%extract%>";

<head><title><!%extract%></title></head><body><pre>
:glcoderow
"<!%glcode%>","<!%po%>","<!%supplier%>","<!%loc%>","<!%costcent%>",<!
%amount%>,<!%accrue%>,"<!%user%>","<!%date%>","<!%name%>"
:trailer
</pre></body></html>
:end

This one is from a web based system. It get thrown at the browser for
saving on their local machine, or directly into
Excel^H^H^H^H^HOpenOffice.org Calc.

If they want an XML file or HTML, or EDIFAC or TAB separated, just
change the template.


.

Relevant Pages

  • Re: MSSQLError overwriting returning XML
    ... results of the template to strip out the errors. ... > MSSQLError processing instructions but to also return a XML that I'm ... > some tables and the stored procedure will always return some other data ... > generates a new value for AuthNo and adds it into the table again. ...
    (microsoft.public.sqlserver.xml)
  • Re: tab and return in mail merge
    ... I don't know about Content Control facilities and I don't see where the .net ... My "template" is saved in Word XML format. ... I am wondering what you mean by a "template" in CRM. ...
    (microsoft.public.word.vba.general)
  • Re: Data entry environment using Word 2003
    ... I suggest using a template centered around the use of Styles, Tables, ... add if VBA can be used Document Variables. ... deletion since style before and after for every element in your document is ... you mean that you wish to use xml schemas and stylesheets then ...
    (microsoft.public.office.developer.web.components)
  • Re: How to serialize Mfc template dialog class ?
    ... I do not believe you can derive a template class from CObject, ... MFC serialization is among the worst possible ways to implement persistent ... tend to use either simple text files or XML files if I have complex structured data. ... ignored the binary form of the file and read the XML form [yes, ...
    (microsoft.public.vc.mfc)
  • Re: Data entry environment using Word 2003
    ... I suggest using a template centered around the use of Styles, Tables, ... add if VBA can be used Document Variables. ... deletion since style before and after for every element in your document is ... you mean that you wish to use xml schemas and stylesheets then ...
    (microsoft.public.office.developer.vba)