Inserting Text at Specific Locations in Delimited Fields

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Inserting Text at Specific Locations in Delimited Fields

Postby lphan » Tue Feb 14, 2006 7:00 am

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: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

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

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 "
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 1 guest