如何使用XSLT 1.0将.csv文件转换为xml？ [英] How to convert .csv file to xml using XSLT 1.0?

问题描述

我有一个.csv文件生成，我想使用xslt将其转换为xml。

如何操作？我不好在xslt。

这是我的.csv档案

  CONTRACT_NUMBER，CLIENT_NAME_FULL，STREET_ADDRESS，REGISTRY_NO，DATE_RECEIVED，STATUS，REMARKS 
 3300016335，name，address，1_A，3/26 /已收到，签名为
  

所需的xml：

 < root> 
< row> 
< CONTRACT_NUMBER> CONTRACT_NUMBER< / CONTRACT_NUMBER> 
< CLIENT_NAME_FULL> CLIENT_NAME_FULL< / CLIENT_NAME_FULL> 
< STREET_ADDRESS> STREET_ADDRESS< / STREET_ADDRESS> 
< REGISTRY_NO> REGISTRY_NO< / REGISTRY_NO> 
< DATE_RECEIVED> DATE_RECEIVED< / DATE_RECEIVED> 
< STATUS> STATUS< / STATUS> 
< REMARKS>备注< / REMARKS> 
< / row> 
< row> 
< CONTRACT_NUMBER> 345678912< / CONTRACT_NUMBER> 
< CLIENT_NAME_FULL>名称< / CLIENT_NAME_FULL> 
< STREET_ADDRESS>地址< / STREET_ADDRESS> 
< REGISTRY_NO> 122345< / REGISTRY_NO> 
< DATE_RECEIVED> 10/10/14< / DATE_RECEIVED> 
< STATUS> fghdsjkls< / STATUS> 
< REMARKS> fdhjgkdfl< / REMARKS> 
< / row> 
< / root> 
  

解决方案

不能使用XSLT。

来自维基百科： / a>

XSLT（可扩展样式表语言转换）是一种将XML文档转换为其他XML文档或其他对象对于网页，纯文本或XSL格式的对象，然后可以转换为PDF，PostScript和PNG。

XSLT可以源XML文档并将其转换为不同的文档（通常是XML，但它可以是任何东西），但XSLT不是一个适当的工具，将CSV数据转换为不同的格式。

I have a .csv file generated and I want to transform it to xml using xslt.

How to do that? I'm not good in xslt. Please, help me.

Thank you.

Here's my .csv file

 CONTRACT_NUMBER,CLIENT_NAME_FULL,STREET_ADDRESS,REGISTRY_NO,DATE_RECEIVED,STATUS,REMARKS
 3300016335,name,"address",1_A,3/26/2014,Received,with signature

Desired xml:

  <root>
    <row>
       <CONTRACT_NUMBER>CONTRACT_NUMBER</CONTRACT_NUMBER>
       <CLIENT_NAME_FULL>CLIENT_NAME_FULL</CLIENT_NAME_FULL>
       <STREET_ADDRESS>STREET_ADDRESS</STREET_ADDRESS>
       <REGISTRY_NO>REGISTRY_NO</REGISTRY_NO>
       <DATE_RECEIVED>DATE_RECEIVED</DATE_RECEIVED>
       <STATUS>STATUS</STATUS>
       <REMARKS>REMARKS</REMARKS>
   </row>
   <row>
       <CONTRACT_NUMBER>345678912</CONTRACT_NUMBER>
       <CLIENT_NAME_FULL>name</CLIENT_NAME_FULL>
       <STREET_ADDRESS>address</STREET_ADDRESS>
       <REGISTRY_NO>122345</REGISTRY_NO>
       <DATE_RECEIVED>10/10/14</DATE_RECEIVED>
       <STATUS>fghdsjkls</STATUS>
       <REMARKS>fdhjgkdfl</REMARKS>
   </row>
  </root>

解决方案

What you're asking for (CSV to XML) cannot be done with XSLT.

From wikipedia:

XSLT (Extensible Stylesheet Language Transformations) is a language for transforming XML documents into other XML documents, or other objects such as HTML for web pages, plain text or into XSL Formatting Objects which can then be converted to PDF, PostScript and PNG.

XSLT can take a source XML document and transform it into a different document (usually XML, but it could be anything), but XSLT is not an appropriate tool for converting CSV data into a different format.

这篇关于如何使用XSLT 1.0将.csv文件转换为xml？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！