I am working on a flat file source. The column names in the source are in form of big questions so they include commas and other special characters as well in column names. Since it is .csv file so the columns are separated by commas for first few column names and for remaining column names which are in form of questions are placed in between double quotes and separated by each other by commas. Now my doubt is while setting the file properties in PowerCenter Designer.
How do i define the column delimiters and as well as the row delimiters so as to read data by skipping the column names?
This is how my file looks:
Number,X,Y,Z,P,Q,R,S,"(A) 1. When you need to look for information about your different mall options, what level of importance do you place on the following information sources? (1- Not at all Important / 10 - Very Important) Website","(A) 1. When you need to look for information about your different mall options, what level of importance do you place on the following information sources? (1- Not at all Important / 10 - Very Important)Website"
1,1,,1,1,1,1,1,1,1
