GitHub user bamaer added a comment to the discussion: CSV file has address field which has commas within,
I can't reproduce your first issue. The enclosure should (and does) allow delimiter characters (commas) within a field. The second issue (data types) is inherent to the schema-less nature of CSV or any type of delimited text files. We scan x number of rows and do the best possible informed guess on the data type. You can manually overrule the detected field type, or scan more rows. You can use 0 to scan the entire file, but that obviously might take a while on large files, and it still is not a 100% guarantee if you use the same layout to read multiple files. GitHub link: https://github.com/apache/hop/discussions/4781#discussioncomment-11841916 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
