CSV2TEI.xsl - Revision history

Piotr Banski: /* Required Input */ changed the invocation of saxon, see the talk page

2007-10-02T10:56:50Z

Required Input: changed the invocation of saxon, see the talk page

← Older revision		Revision as of 10:56, 2 October 2007
Line 9:		Line 9:
	Using [[Saxon]] 8 or above use it as:		Using [[Saxon]] 8 or above use it as:

	'''~~saxon~~ -it main CSV2TEI.xsl input-uri=filename.csv'''		'''java -jar saxon8.jar -it main CSV2TEI.xsl input-uri=filename.csv'''

	So input can be any file resembling:		(The "-it main" option tells the processor to invoke the "main" template by name, and the "input-uri" is a parameter that we pass to that template.)

			So input can be any file (in our example, "filename.csv") resembling:
	<pre>		<pre>
	~~<nowiki>~~
	This,is,a,test,only,a,test		This,is,a,test,only,a,test
	This, is a, variation, on a, test		This, is a, variation, on a, test
	"This","is","another","variation."		"This","is","another","variation."
	~~</nowiki>~~
	</pre>		</pre>

Piotr Banski: /* Required Input */ + link, stylesheet->CSV2TEI, see talk page

2007-10-02T10:21:12Z

Required Input: + link, stylesheet->CSV2TEI, see talk page

← Older revision		Revision as of 10:21, 2 October 2007
Line 7:		Line 7:
	== Required Input ==		== Required Input ==

	Using Saxon 8 or above use it as:		Using [[Saxon]] 8 or above use it as:

	'''saxon -it main ~~styesheet~~.xsl input-uri=filename.csv'''		'''saxon -it main CSV2TEI.xsl input-uri=filename.csv'''

	So input can be any file resembling:		So input can be any file resembling:
Line 19:		Line 19:
	</nowiki>		</nowiki>
	</pre>		</pre>


	== Expected Output ==		== Expected Output ==

Piotr Banski: Reverted edit of KqlY9b, changed back to last version by Piotr Banski

2007-07-13T10:46:09Z

Reverted edit of KqlY9b, changed back to last version by Piotr Banski

New page

== Summary ==

This stylesheet takes a comma-separated-values file and converts it to a basic TEI table structure.

Add any comments to the 'discussion' tab.

== Required Input ==

Using Saxon 8 or above use it as:

'''saxon -it main styesheet.xsl input-uri=filename.csv'''

So input can be any file resembling:
<pre>
<nowiki>
This,is,a,test,only,a,test
This, is a, variation, on a, test
"This","is","another","variation."
</nowiki>
</pre>

== Expected Output ==

The output is a TEI table with table, rows and cells but nothing else which can then be cut-and-pasted into a TEI document.
For example, with the above input, the output should be:
<pre>
<nowiki>
<table>
<row>
<cell>This</cell>
<cell>is</cell>
<cell>a</cell>
<cell>test</cell>
<cell>only</cell>
<cell>a</cell>
<cell>test</cell>
</row>
<row>
<cell>This</cell>
<cell>is a</cell>
<cell>variation</cell>
<cell>on a</cell>
<cell>test</cell>
</row>
<row>
<cell>This</cell>
<cell>is</cell>
<cell>another</cell>
<cell>variation.</cell>
</row>
</table>
</nowiki>
</pre>

== Known Restrictions or Problems ==

Note:
* It assumes cells are comma separated and rows are on individual lines
* If surrounded in double-quotes, it will remove them.
* It normalize-space()s the individual cell contents so leading/trailing spaces
are removed.
* It assumes things are in UTF-8 but this can be changed with the encoding
parameter output is converted to UTF-8.
* It is an XSLT2 stylesheet and requires an XSLT2 processor such as Saxon8

== Stylesheet ==
<pre>
<nowiki>
<?xml version="1.0"?>


<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
version="2.0" exclude-result-prefixes="#all">
<xsl:param name="input-uri" as="xs:string"/>
<xsl:param name="encoding" select="'UTF-8'" as="xs:string"/>
<xsl:output indent="yes" encoding="UTF-8" />

<xsl:template name="main">
<xsl:variable name="in"
select="unparsed-text($input-uri, $encoding)"/>
<table>
<xsl:analyze-string select="$in" regex="\n">
<xsl:non-matching-substring>
<row>
<xsl:analyze-string select="."
regex='("([^"]*?)")|([^,]+?),'>
<xsl:matching-substring>
<cell>
<xsl:value-of select="normalize-space(regex-group(2))"/>
<xsl:value-of select="normalize-space(regex-group(3))"/>
</cell>
</xsl:matching-substring>
</xsl:analyze-string>
</row>
</xsl:non-matching-substring>
</xsl:analyze-string>
</table>
</xsl:template>

</xsl:stylesheet>
</nowiki>
</pre>

[[Category:XSLT]]
[[Category:XSLT:2.0]]

Piotr Banski: revert

2007-06-22T13:30:48Z

revert

New page

Piotr Banski: revert

2007-06-03T02:21:49Z

revert

New page

James at 16:07, 20 January 2006

2006-01-20T16:07:42Z

← Older revision		Revision as of 16:07, 20 January 2006
Line 14:		Line 14:
	<pre>		<pre>
	<nowiki>		<nowiki>
	This,is,a,test,only,a,test!		This,is,a,test,only,a,test
	This, is a, variation, on a, test!		This, is a, variation, on a, test
	"This","is","another","variation."		"This","is","another","variation."
	</nowiki>		</nowiki>
Line 35:		Line 35:
	<cell>only</cell>		<cell>only</cell>
	<cell>a</cell>		<cell>a</cell>
			<cell>test</cell>
	</row>		</row>
	<row>		<row>
Line 41:		Line 42:
	<cell>variation</cell>		<cell>variation</cell>
	<cell>on a</cell>		<cell>on a</cell>
			<cell>test</cell>
	</row>		</row>
	<row>		<row>

James: Reverted edit of Recito, changed back to last version by Stuart

2006-01-20T16:02:54Z

Reverted edit of Recito, changed back to last version by Stuart

New page

== Summary ==

This stylesheet takes a comma-separated-values file and converts it to a basic TEI table structure.

Add any comments to the 'discussion' tab.

== Required Input ==

Using Saxon 8 or above use it as:

'''saxon -it main styesheet.xsl input-uri=filename.csv'''

So input can be any file resembling:
<pre>
<nowiki>
This,is,a,test,only,a,test!
This, is a, variation, on a, test!
"This","is","another","variation."
</nowiki>
</pre>

== Expected Output ==

The output is a TEI table with table, rows and cells but nothing else which can then be cut-and-pasted into a TEI document.
For example, with the above input, the output should be:
<pre>
<nowiki>
<table>
<row>
<cell>This</cell>
<cell>is</cell>
<cell>a</cell>
<cell>test</cell>
<cell>only</cell>
<cell>a</cell>
</row>
<row>
<cell>This</cell>
<cell>is a</cell>
<cell>variation</cell>
<cell>on a</cell>
</row>
<row>
<cell>This</cell>
<cell>is</cell>
<cell>another</cell>
<cell>variation.</cell>
</row>
</table>
</nowiki>
</pre>

== Known Restrictions or Problems ==

Note:
* It assumes cells are comma separated and rows are on individual lines
* If surrounded in double-quotes, it will remove them.
* It normalize-space()s the individual cell contents so leading/trailing spaces
are removed.
* It assumes things are in UTF-8 but this can be changed with the encoding
parameter output is converted to UTF-8.
* It is an XSLT2 stylesheet and requires an XSLT2 processor such as Saxon8

== Stylesheet ==
<pre>
<nowiki>
<?xml version="1.0"?>


<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
version="2.0" exclude-result-prefixes="#all">
<xsl:param name="input-uri" as="xs:string"/>
<xsl:param name="encoding" select="'UTF-8'" as="xs:string"/>
<xsl:output indent="yes" encoding="UTF-8" />

<xsl:template name="main">
<xsl:variable name="in"
select="unparsed-text($input-uri, $encoding)"/>
<table>
<xsl:analyze-string select="$in" regex="\n">
<xsl:non-matching-substring>
<row>
<xsl:analyze-string select="."
regex='("([^"]*?)")|([^,]+?),'>
<xsl:matching-substring>
<cell>
<xsl:value-of select="normalize-space(regex-group(2))"/>
<xsl:value-of select="normalize-space(regex-group(3))"/>
</cell>
</xsl:matching-substring>
</xsl:analyze-string>
</row>
</xsl:non-matching-substring>
</xsl:analyze-string>
</table>
</xsl:template>

</xsl:stylesheet>
</nowiki>
</pre>

[[Category:XSLT]]
[[Category:XSLT:2.0]]

Stuart: Nasty spam links removed

2006-01-19T12:02:04Z

Nasty spam links removed

New page

== Summary ==

This stylesheet takes a comma-separated-values file and converts it to a basic TEI table structure.

Add any comments to the 'discussion' tab.

== Required Input ==

Using Saxon 8 or above use it as:

'''saxon -it main styesheet.xsl input-uri=filename.csv'''

So input can be any file resembling:
<pre>
<nowiki>
This,is,a,test,only,a,test!
This, is a, variation, on a, test!
"This","is","another","variation."
</nowiki>
</pre>

== Expected Output ==

The output is a TEI table with table, rows and cells but nothing else which can then be cut-and-pasted into a TEI document.
For example, with the above input, the output should be:
<pre>
<nowiki>
<table>
<row>
<cell>This</cell>
<cell>is</cell>
<cell>a</cell>
<cell>test</cell>
<cell>only</cell>
<cell>a</cell>
</row>
<row>
<cell>This</cell>
<cell>is a</cell>
<cell>variation</cell>
<cell>on a</cell>
</row>
<row>
<cell>This</cell>
<cell>is</cell>
<cell>another</cell>
<cell>variation.</cell>
</row>
</table>
</nowiki>
</pre>

== Known Restrictions or Problems ==

Note:
* It assumes cells are comma separated and rows are on individual lines
* If surrounded in double-quotes, it will remove them.
* It normalize-space()s the individual cell contents so leading/trailing spaces
are removed.
* It assumes things are in UTF-8 but this can be changed with the encoding
parameter output is converted to UTF-8.
* It is an XSLT2 stylesheet and requires an XSLT2 processor such as Saxon8

== Stylesheet ==
<pre>
<nowiki>
<?xml version="1.0"?>


<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
version="2.0" exclude-result-prefixes="#all">
<xsl:param name="input-uri" as="xs:string"/>
<xsl:param name="encoding" select="'UTF-8'" as="xs:string"/>
<xsl:output indent="yes" encoding="UTF-8" />

<xsl:template name="main">
<xsl:variable name="in"
select="unparsed-text($input-uri, $encoding)"/>
<table>
<xsl:analyze-string select="$in" regex="\n">
<xsl:non-matching-substring>
<row>
<xsl:analyze-string select="."
regex='("([^"]*?)")|([^,]+?),'>
<xsl:matching-substring>
<cell>
<xsl:value-of select="normalize-space(regex-group(2))"/>
<xsl:value-of select="normalize-space(regex-group(3))"/>
</cell>
</xsl:matching-substring>
</xsl:analyze-string>
</row>
</xsl:non-matching-substring>
</xsl:analyze-string>
</table>
</xsl:template>

</xsl:stylesheet>
</nowiki>
</pre>

[[Category:XSLT]]
[[Category:XSLT:2.0]]

James at 14:17, 13 January 2006

2006-01-13T14:17:13Z

← Older revision		Revision as of 14:17, 13 January 2006
Line 16:		Line 16:
	This,is,a,test,only,a,test!		This,is,a,test,only,a,test!
	This, is a, variation, on a, test!		This, is a, variation, on a, test!
	"This","is","another","variation." ~~It is an XSLT2 stylesheet and requires an XSLT2 processor such as Saxon8~~		"This","is","another","variation."
	</nowiki>		</nowiki>
	</pre>		</pre>

James: Reverted edit of 2chemp, changed back to last version by James

2005-11-14T10:58:13Z

Reverted edit of 2chemp, changed back to last version by James

← Older revision	Revision as of 10:58, 14 November 2005
(No difference)