Inserting Text at Specific Locations in Delimited Fields

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Inserting Text at Specific Locations in Delimited Fields

Post by lphan » Tue Feb 14, 2006 7:00 am


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


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


Thanks for all your help guys. BTW textpipe rocks!

User avatar
DataMystic Support
Site Admin
Posts: 2238
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by DataMystic Support » Thu Feb 16, 2006 3:56 pm


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 "

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads

Post Reply