Question
BRESATECH
US
Last activity: 27 Dec 2019 17:54 EST
Please help me format my one record Excel document that will be input to my file listener.
I developed a file listener with the following rules: Parse Delimited rule, Activity (Parse Activity), Service Package rule, Service Request Processor rule, Service File rule, File Listener rule.
When I tested my Service File I got the following error message: com.pega.pegarules.pub.PRException: Error while parsing: Invalid escape sequence. Escape character must be followed by either field delimiter, or record delimiter, or another escape character.
Can someone show me how to properly format the escape sequence for my Excel input file please?
I have attached my Excel file, Service File and Parse Delimited Rule. Thank you in advance.
BRESATECH
US
Thank you RakeshBurbur for your response, I changed my Excel document using \\ as you suggested, my Parse Delimited and Service rules are unchanged. I received the same error message. I have uploaded my revised Excel document.
BRESATECH
US
The following Pega Community Knowledgebase topic https://community.pega.com/knowledgebase/articles/how-parse-comma-separated-value-csv-files helped me resolve my Excel file parsing issue. Thank you RakeshBurBur.