eRROR READING file
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
srk0609
8 - Asteroid
‎08-01-2022
02:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm trying to read xml file as csv and I 'm getting following error any idea how to deal with this error?
Please help. Thank you.
Input Data (13) Error reading "S:\accounting\Duco\05-Reconciliations\CPN1_to_Indixis\z.wrk\Aurelien's files\07262022\ROC_XML_MX_FX_C_20220726.xml": Too many fields in record #1349945
Labels:
1 REPLY 1
Luke_C
17 - Castor
‎08-01-2022
02:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Look at record 1,349,945. It sounds like there's probably a data issue - an extra field.
You could read in the data with no delimiter (set to \0). Then do a text to columns tool - you should be able to see the data that's causing this issue.