-
Notifications
You must be signed in to change notification settings - Fork 10
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Get csv file with quotation option #2
Comments
I am having the same issue. When using the standard "|" as the delimiter, the "visit_details.csv" and "page_details.csv" are failing to import using the Viya based /SASDataExplorer and the error leads me to believe that some of the fields have a | int he field. One way to get around this is as marcosarmas mentioned, which is to encapsulate the text fields in " so that, in this example, "b|ar" is not parsed into two fields: Otherwise, unless I am missing something, the options are to use a multi-character delimiter such as Do you have other advice? |
Hi Marcos, I figured out a workaround yesterday. It seemed that every single special character that was a standard ASCII character was also in my dataset, so we used a multi-character delimiter to ensure we had good field boundaries (using the -cd parameter): We later learned of a limitation in the application we were using to import the data, so we used sed to replace --- Request to the developers --- please include a parameter(s) to allow for quoting the field boundaries to account for the situation where a delimiter could exist inside the field value ... as I understand it, the you can pass an option (quote full or quote partial) to the standard: |
Hi Andy, Great solution! I go to try it! Cheers. |
Hi,
I'm working with this client to download Discover data, but I'm having problems choosing a good delimiter, there is a way to quote the text fields?
thanks,
Marcos.
The text was updated successfully, but these errors were encountered: