Inserting Text at Specific Locations in Delimited Fields

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
lphan
Posts: 3
Joined: Tue Feb 14, 2006 3:57 am

Inserting Text at Specific Locations in Delimited Fields

Post by 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!
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by 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 "
Post Reply