Data source issues with semicolon (;) delimiters while importing a CSV
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2022 01:14 AM
I'm importing a CSV file from an SFTP server but I'm running into an issue where the semicolon delimiter doesn't seem to be working. When loaded, the columns are not separated properly. The delimiter should be a semicolon and is set as such in the data source settings. The CSV is UTF-8 but there seems to be a problem for Service Now understanding it. Setting the properties as "charset=utf-8" does not seem to help either.
Has anyone run into a similar issue? If so, how did you resolve it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-08-2022 03:10 AM
Not sure what the issue exactly was. Creating a completely new data source with the same settings seemed to have fixed the problem.
