Question
NTT Data
US
Last activity: 19 Jun 2018 17:14 EDT
Need Delimiter as "&" or "%" in BIX Extract files
Hello Team,
Could you please help me how to put "&" or "%" as a Delimiter in BIX Extract files. We are not running the files in Command Line
Note: We have selected CSV format file.
***Edited by Moderator Marissa to update platform capability tags***
Pegasystems Inc.
US
Are you running the extracts through an agent since you are not running from the command line? Assuming you are running using an agent running pxExtractDataWithArgs you would pass this as a command line parameter to the activity.
You can change the delimiter with the -l property
https://community.pega.com/system/files/pdfs/BIX%207.3.1%20User%20Guide.pdf
-l <delimiter> Specify a user-defined character as the delimiter separating extracted data.
The following characters are not available for use as delimiters, as they signify other things to BIX:
l Double-quote (“)
l Asterisk (*)
Are you running the extracts through an agent since you are not running from the command line? Assuming you are running using an agent running pxExtractDataWithArgs you would pass this as a command line parameter to the activity.
You can change the delimiter with the -l property
https://community.pega.com/system/files/pdfs/BIX%207.3.1%20User%20Guide.pdf
-l <delimiter> Specify a user-defined character as the delimiter separating extracted data.
The following characters are not available for use as delimiters, as they signify other things to BIX:
l Double-quote (“)
l Asterisk (*)
l Hyphen (-)
BIX also does not support multi-line delimiters. If the delimiter length is greater than 1, then BIX reports an
error.
NTT Data
US
Thanks Celeste,
Did it worked for you? We tried multiple options but didn't worked for me.
As of now, we are running the pxExtractDataWithArgs Activity manually and passing the the Extract rule name and its Class name to the activity
Could you please share me the code(worked) where we have to pass the Args?
Note: Extract rule Output format is CSV
Thank you.