Monday, April 20, 2020

keep comma separated values as one string in csv peoplesoft

Enclose double quotes (") around the string which contains comma as highlighted below.


&report.WriteLine(&busprocname | "," | &activityname | "," | &eventname | "," | &worklistname | "," | &instanceid | "," | &transactionid | "," | &eoawprcs_id | "," | &eoawthread_id | "," | &eoawdefn_id | "," | &effdt | ",""" | &eoawdescr | """");