Support Article
Parse rule does not parse the fields with "\"
SA-35740
Summary
Parse an CSV file using Parse Delimited rule and calling the rule from activity using "Apply-Parse-Delimited". CSV file having odd number of "\", does not parse the field.
Error Messages
Error while parsing: Invalid escape sequence. Escape character must be followed by either field delimiter
Steps to Reproduce
1. Create a parse delimited rule with filed format as CSV.2. Provide one \ in one of the filed in CSV file.
3. Run the Parse rule and provide the CSV file as input.
Root Cause
Not Applicable
Resolution
Perform the following local-change:
Use either "\\" or "/" in the parse rule.
Published April 11, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.