Posted: 23 Dec 2019 23:15 EST 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.
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.