XML to CSV with missing attributes

[Fixer]

How to convert XML to CSV when sometimes we have a missing attributes (param2, param3)?

input xml file

Code: Select all

<?xml version='1.0' encoding='iso-8859-2'?>
<details>
  <item param1="123" param2="321" param3="TWOFIL"/>
  <item param1="456" param2="534"/>
  <item param1="789" param3="GTREW"/>
  ...
</details>

output csv format:

Code: Select all

123;321;TWOFIL
456;534;;
789;;GTREW

[DataMystic Support]

Use an optional perl pattern

Code: Select all

(param3="(.*)")?

or an optional EasyPattern:

Code: Select all

[ optional( 'param3="', capture(1+chars), '"') ]

[Fixer]

thx it works