# Flat/XML Resources

## Flat File Formats

### CSV

- Wikapedia Comma-separated values

- Wikapedia Delimiter-separated values

- RFC 4180 Common Format and MIME Type for Comma-Separated Values (CSV) Files

- Creativyst Software The Comma Separated Value (CSV) File Format

- Kasper B. Graversen The CSV format specification

### Legacy File Formats

- Michael C. Rawlins Processing Legacy File Formats with XML and the DOM

- Michael C. Rawlins Using XML with Legacy Business Applications

- Jean-Yves MENGANT JURASSIC FAQS

- IBM SMF records

- IBM WebSphere Business Integration Adapters documentation SWIFT message structure

### Tools

- ServingXML

- XML Convert

- Babel Blaster

- Jasper ETL

- Spring Batch

- RefleX

## Character Encoding

- Unicode

- Addison P. Phillips Are We Counting Bytes Yet?

- ICU International Components for Unicode

## Flat/XML Markup

- Bob Lyons Converting Flat File Content into XML and Vice Versa

- Daniel Parker Markup for Flat-XML Processing

## Flat/XML Conversion with XSLT

- XSLT FAQ Flat file transformation

- Michael Kay Up-conversion using XSLT 2.0

- Jeni Tennison Flattening Input

- Andrew Welch A CSV to XML converter in XSLT 2.0 (version 2)

## Grouping XML Tags with XSLT

- Jeni Tennison Grouping

## Streaming XML

- Streaming Transformations for XML (STX)

## Standards Related to Flat/XML Transformation

### ISO

- SQL/XML

- Schematron

### Oasis

- WS BPEL 2.0

- RELAX NG

### W3C

- XML Path Language (XPath) 2.0

- XSL Transformations (XSLT) Version 2.0

- XQuery 1.0: An XML Query Language

- XML Schema

  - XML Schema: Primer
  - XML Schema: Structures
  - XML Schema: Datatypes

## Tutorials

- XQUERY

  - Michael Kay Learn XQuery in 10 Minutes

  - Michael Kay Blooming FLWOR - An Introduction to the XQuery FLWOR Expression

  - Michael Kay Schema-Aware Queries and Stylesheets

- XML Schema

  - W3Schools Introduction to XML Schema

  - ZVON W3Schools.com XML Schema Tutorial

- XPATH

  - W3Schools W3Schools.com XPATH Tutorial

  - ZVON ZVON XPath Tutorial

- XSLT

  - W3Schools W3Schools.com XSL Tutorial

  - ZVON ZVON XSLT Tutorial

## Datatype Mappings

- IBM XML schema to SQL types compatibility for annotated schema decomposition

- CASTOR Type Support

- Hibernate Controlling reverse engineering

- Oracle Oracle XML DB API for Java Beans

- SUN Automatic Schema Generation

- Elliotte Rusty Harold Parsing non-XML Documents

## Regular Expressions

- stevesoft Regular Expressions

## File Verification

- Mark Nelson File Verification Using CRC