Inserting Text at Specific Locations in Delimited Fields

[lphan]

Field1,Field2,Field3,Field4,Field5

In the Delimited Fields Above, how can i insert quotation marks (") at the beginning of each delimited field to look like below.

"Field1","Field2","Field3","Field4","Field5"

I come accross this problem when altering a CSV file and changing it back to text. i always lose the quotations. i want to use textpipe to reinsert those quoations back.

Also, if i wanted to add quotations to just a specific field (Field3) like below, how would i do it

Field1,Field2,"Field3",Field4,Field5

Thanks for all your help guys. BTW textpipe rocks!

[DataMystic Support]

Thanks!

Just use an Add Header of " and Add Footer of " inside a Restrict to Delimited fields filter, applied to just field 3.

A faster way is to just search/replace , with ","
then add a Left Margin of " and a Right Margin of "