Double quotes can be used within text fields, but they have to be inserted differently than in your example (which cannot be processed by PowerCenter, it's that simple).
In the flat file source definition, you can define a "quoting character" (often a backslash is used in similar cases); then each double quote within a text field (which must be quoted by single or double quotes, otherwise newline characters cannot be embedded in such fields) must be prepended by this "quoting character".
In your example, assuming the quoting character is a backslash, the input file needs to look like this: (third line only)
1999,Chevy,"Venture \"Extended Edition, Very Large\"",,5000.0
If the creator of the file cannot change the file format, you will need some other method to read and parse the input file. For example, a shell script to perform the change described above. Or a Java transformation which parses the input file on its own without using features of the PowerCenter file reader.
1 of 1 people found this helpful
You can achieve this requirement using Inbuilt functions in the mapping.
For 3rd field, check "" in the field string using INSTR. When it return 0, then no quotes otherwise concat "" to this field.
For 4th field, Perform concat the double quotes for the string.
Directly write into Target Flat file as comma delimited file.