$csv to xml

Allows you to convert a CSV file to XML.


Example

Running this code will set a variable named "#Debug2", converting the csv string to "xml" type:

<Root>
  <XElement>
    <Rank>1</Rank>
    <URL>facebook.com/</URL>
    <Linking_Root_Domains>9616487</Linking_Root_Domains>
    <External_Links>1688316928</External_Links>
    <mozRank>9.54</mozRank>
    <mozTrust>9.34</mozTrust>
  </XElement>
  <XElement>
    <Rank>2</Rank>
    <URL>twitter.com/</URL>
    <Linking_Root_Domains>6454936</Linking_Root_Domains>
    <External_Links>2147483647</External_Links>
    <mozRank>9.4</mozRank>
    <mozTrust>9.25</mozTrust>
  </XElement>
  <XElement>
    <Rank>3</Rank>
    <URL>google.com/</URL>
    <Linking_Root_Domains>5868081</Linking_Root_Domains>
    <External_Links>807173458</External_Links>
    <mozRank>9.3</mozRank>
    <mozTrust>9.27</mozTrust>
  </XElement>
  <XElement>
    <Rank>4</Rank>
    <URL>youtube.com/</URL>
    <Linking_Root_Domains>5442206</Linking_Root_Domains>
    <External_Links>841281214</External_Links>
    <mozRank>9.25</mozRank>
    <mozTrust>9.11</mozTrust>
  </XElement>
  <XElement>
    <Rank>5</Rank>
    <URL>wordpress.org/</URL>
    <Linking_Root_Domains>4051288</Linking_Root_Domains>
    <External_Links>361023992</External_Links>
    <mozRank>8.99</mozRank>
    <mozTrust>8.71</mozTrust>
  </XElement>
  <XElement>
    <Rank>6</Rank>
    <URL>adobe.com/</URL>
    <Linking_Root_Domains>3498190</Linking_Root_Domains>
    <External_Links>232289315</External_Links>
    <mozRank>9.3</mozRank>
    <mozTrust>9.27</mozTrust>
  </XElement>
  <XElement>
    <Rank>7</Rank>
    <URL>blogspot.com/</URL>
    <Linking_Root_Domains>3073493</Linking_Root_Domains>
    <External_Links>793032047</External_Links>
    <mozRank>8.77</mozRank>
    <mozTrust>8.71</mozTrust>
  </XElement>
  <XElement>
    <Rank>8</Rank>
    <URL>wikipedia.org/</URL>
    <Linking_Root_Domains>2917053</Linking_Root_Domains>
    <External_Links>206217734</External_Links>
    <mozRank>8.83</mozRank>
    <mozTrust>8.72</mozTrust>
  </XElement>
  <XElement>
    <Rank>9</Rank>
    <URL>linkedin.com/</URL>
    <Linking_Root_Domains>2435569</Linking_Root_Domains>
    <External_Links>327700219</External_Links>
    <mozRank>8.95</mozRank>
    <mozTrust>8.81</mozTrust>
  </XElement>
  <XElement>
    <Rank>10</Rank>
    <URL>wordpress.com/</URL>
    <Linking_Root_Domains>2340965</Linking_Root_Domains>
    <External_Links>569397042</External_Links>
    <mozRank>8.65</mozRank>
    <mozTrust>8.6</mozTrust>
  </XElement>
</Root>

Here is the code view for reference:

set(#Debug2,$plugin function("Data and Files Automation.dll", "$csv to xml", "Rank,URL,Linking Root Domains,External Links,mozRank,mozTrust
1,facebook.com/,9616487,1688316928,9.54,9.34
2,twitter.com/,6454936,2147483647,9.4,9.25
3,google.com/,5868081,807173458,9.3,9.27
4,youtube.com/,5442206,841281214,9.25,9.11
5,wordpress.org/,4051288,361023992,8.99,8.71
6,adobe.com/,3498190,232289315,9.3,9.27
7,blogspot.com/,3073493,793032047,8.77,8.71
8,wikipedia.org/,2917053,206217734,8.83,8.72
9,linkedin.com/,2435569,327700219,8.95,8.81
10,wordpress.com/,2340965,569397042,8.65,8.6"),"Global")

Was this helpful?

Previous Article

$csv to string

Next Article

$file info