Question
Parse CSV file (tab separated or tab delimited)
Hi All, I am receiving CSV file via email, which the email listener then creates a case with an attachment. I need to parse this attached CSV file and create a page list from it. This CSV file is 'tab separated'.
How can I parse a tab-separated CSV file in Pega?
I am aware that the Parse-Delimiter rule with a custom Definition option can be used. The Delimiter can be set to '\t' and the Processing method in the parse rule can be set to 'use parse details'.
However, what needs to be configured in the Parsing Details section?
My goal is to parse both the header and the details, and create a page list for each row in the CSV file. Sample CSV file data: PFA