+23While the csv reader can have a delimiter specified, it would be great if a setting was introduced that would allow the CSV Reader to guess the delimiter of the supplied file (just in the same way generic reader can guess a format).
This way the similar files using different delimiters could be read without the CSV delimiter needing to be pasted by early processing to guess the delimiter.
+8What are valid delimiters? As per Excel (comma, tab, semi-colon, space)?
If FME is guessing the delimiter it increases the risk of mistaking a value for a delimiter so it would be more important to encapsulate values in quotes.
+23
+22This idea was implemented in FME 2019--the CSV reader now has an 'Auto' option in the Delimiter Character reader parameter! FME will automatically guess the delimited character if Auto is selected and this option is also the default value for the Delimiter Character parameter.
Should this feature or its implementation not address your concerns, please let us know by leaving a comment.
+8Hi compliments for this nice idea. Wanted to upvote.
+23This still needs work — adding the Crime csv from the Basic training course into a 2020.1 CSV reader still requires the delimiter to be set to <comma>. <Auto> does NOT separate the columns:
<edited for correct screenshot!>
'>
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
