Question
Atos Syntel
IN
Last activity: 10 Jul 2025 10:07 EDT
How to remove double quotes from BIX extract in CSV format ?
When extracting data in CSV format using BIX, all values are enclosed in double quotes "" like below, how can i remove this.
Pegasystems Inc.
CA
Please check this link.
https://community.pega.com/support/support-articles/bix-extract-csv-file-issue?
Atos Syntel
IN
@RameshSangili the solution provided solved the space issue, but the quotes are still there.
Pegasystems Inc.
CA
Can you please try with a delimiter?
| -l <delimiter> | Specify a user-defined character as the delimiter separating extracted data.
Note: The following characters are not available for use as delimiters, as they signify other things to BIX:
BIX also does not support multi-line delimiters. If the delimiter length is greater than 1, then BIX reports an error. |
Atos Syntel
IN
@RameshSangili tried pipe delimiter, still getting quotes, passed "-l \"|\"" as pyArgs to pxExtractDataWithArgs
HCA Healthcare
US
To remove double quotes from a BIX extract in CSV format, check the extract rule settings first. In the export configuration, find the "Text Qualifier" setting, which by default adds double quotes around fields. Set the "Text Qualifier" to an empty string ("") to stop it from adding quotes. After updating the extract rule, save the changes and re-run the export to see if the double quotes are removed. If this doesn't work, you can also remove the double quotes from the generated CSV file by using a script, like in Python, to replace the quotes with nothing. Simply read the file and rewrite it without quotes. For more details, you can also check Pega’s official support page for further guidance