Forum Discussion
ignoring Line breaks within quotes while importing folder
To be honest, I'm not familiair with these specific options, but I do have an idea.
I would try and import 1 file with the options as indicated, next import the files from the folder and then adjust the relevant part of the generated code with the corresponding part of the code that was first generated for 1 file.
When importing files from a folder and combining them, you get several query objects.
The object that you should adjust is the query that transforms the example file, you can find at the location similar to this screenshot:
Probably it's most convenient to apply the adjustments via the Advanced Editor.
To be honest, I'm not familiair with these specific options, but I do have an idea.
I would try and import 1 file with the options as indicated, next import the files from the folder and then adjust the relevant part of the generated code with the corresponding part of the code that was first generated for 1 file.
When importing files from a folder and combining them, you get several query objects.
The object that you should adjust is the query that transforms the example file, you can find at the location similar to this screenshot:
Probably it's most convenient to apply the adjustments via the Advanced Editor.
For anyone looking for the exact code, follow Marcel's advice and go into the "Transform Sample File.." settings. Then go to the source and click on the gear icon and make sure to change the QuoteStyle from .None to .CSV --> "QuoteStyle=QuoteStyle.Csv"
This is awesome ! Just how i wanted to work !! Thanks a lot :)
