Would someone be able to help me out in what attributes should be added to the TPT script to extract the data with a delimiter and the values of individual column are enclosed in single quotes.
What version of TPT are you running?
Hopefully, at least 14.10.
In the DataConnector Consumer operator list of attributes, make sure QuotedData is set to 'yes'.
Whether you use the Export operator or the Selector operator (with ReportMode) is dependent upon the version of TPT you are running.