Split XML into different row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Problems
I got an XML file and I have to set the file format as ".*XML" instead of "*.CSV", and I got the output as below attached screenshot.
I would like to know how to split the data into different row?
Expected Result
<submission> |
<form> |
<formId>AA0121</formId> |
<captchaMethod>DX_RISKLEVEL</captchaMethod> |
... |
</form> |
<submit> |
<trnId>AA012163QPS1LN51</trnId> |
... |
</submit> |
<data> |
<clientContactAddress>CA</clientContactAddress> |
... |
</data> |
</submission> |
Solved! Go to Solution.
- Labels:
- Developer Tools
- Help
- Macros
- Regex
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @flying008
Since I got a new XML file, it contains 3 different child element (form, submit, data) under the parent element (submission). Compare with this XML file, the last XML file it just contains 2 child elements (form and submit).
Therefore, it seems like I cannot use the same method to split the data.
The file that I have uploaded above is the latest XML file, and I’m also wondering is there any methods that allows me to split the XML into different row, without changing the file format to ‘flat’ to archive the same result?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @tamluenwai
Depending on the structure of your existing file, it is not possible to import it in XML format to just get the wrap result, you have to wrap the line after the input to achieve the output you want. ( .csv and .xml formats all both can be input like @Manoj_k , but the options are different, and you need to wrap the line later.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your help!! It works perfectly. I have been stuck to this problems for a few days already.
