|
| |
(Pro
version only)
Converts CSV data (quoted or unquoted) to XML form. It's preferable to use a
file with column headers, because then TextPipe can easily determine if the
fields have embedded CR/LFs in them. If the data is properly quoted then
TextPipe will determine this automatically.
e.g. Input CSV file:
1,,3,,5,,7,,9,,11,,13,
"1","2","3","4","5","6","7","8","9","10","11","12","13","14"
1,2,3,4,5,6,7,8,9,10,11,12,13,14
1,2,3,4,5,6,7,8,9,10,11,12,13,
"1","2","3","4","53424""34242","""3243246","7","8","9","10","11","12","13","14"
Output XML format
<line>
<field1>1</field1>
<field2></field2>
<field3>3</field3>
<field4></field4>
<field5>5</field5>
<field6></field6>
<field7>7</field7>
<field8></field8>
<field9>9</field9>
<field10></field10>
<field11>11</field11>
<field12></field12>
<field13>13</field13>
<field14></field14>
</line>
<line>
<field1>1</field1>
<field2>2</field2>
<field3>3</field3>
<field4>4</field4>
<field5>5</field5>
<field6>6</field6>
<field7>7</field7>
<field8>8</field8>
<field9>9</field9>
<field10>10</field10>
<field11>11</field11>
<field12>12</field12>
<field13>13</field13>
<field14>14</field14>
</line>
<line>
<field1>1</field1>
<field2>2</field2>
<field3>3</field3>
<field4>4</field4>
<field5>5</field5>
<field6>6</field6>
<field7>7</field7>
<field8>8</field8>
<field9>9</field9>
<field10>10</field10>
<field11>11</field11>
<field12>12</field12>
<field13>13</field13>
<field14>14</field14>
</line>
<line>
<field1>1</field1>
<field2>2</field2>
<field3>3</field3>
<field4>4</field4>
<field5>5</field5>
<field6>6</field6>
<field7>7</field7>
<field8>8</field8>
<field9>9</field9>
<field10>10</field10>
<field11>11</field11>
<field12>12</field12>
<field13>13</field13>
<field14></field14>
</line>
<line>
<field1>1</field1>
<field2>2</field2>
<field3>3</field3>
<field4>4</field4>
<field5>53424"34242</field5>
<field6>"3243246</field6>
<field7>7</field7>
<field8>8</field8>
<field9>9</field9>
<field10>10</field10>
<field11>11</field11>
<field12>12</field12>
<field13>13</field13>
<field14>14</field14>
</line>
|
