Help with conversion

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

like2golf
Posts: 1
Joined: Wed Feb 08, 2006 10:10 am

Help with conversion

Postby like2golf » Wed Feb 08, 2006 10:17 am

I've got a rather large CSV data file that has a the following column:

"Air Tools & Accessories///Air Impact Wrenches///1/2"" Drive"
"Air Tools & Accessories///Air Impact Wrenches///3/8"" Drive"
"Air Tools & Accessories///Air Ratchets///1/4"" Drive"
Vehicle Specialty Tools///Wheel & Tire Service///Wheel Tools
"Shop Tools,Equipment & Supplies///Shop Air///Blow Guns"
Air Tools & Accessories///Air Tool Accessories///Parts
"Shop Tools,Equipment & Supplies///Shop Air///Blow Guns"
"Shop Tools,Equipment & Supplies///Shop Air///Hoses and Reels"

I want to convert this column into a set of three TAB delimited columns (or a set of three comma delimited columns) and am not having any luck. Mainly due to the fact that some records start with " and others don't (due to commas in the field, or " as an indicator of inches)

I've tried replacing the /// with a /t and that works great for the records that don't start with a ", but for those that do, Excel reads as one column with tabs.

What's the best way to convert this column into three?

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

Postby DataMystic Support » Wed Apr 19, 2006 8:39 am

TextPipe doesn't care if your CSV fields are quote delimited or not.

Just use a Restrict to Delimited Fields (CSV) filter, and inside this, a search\replace of '/' with '\t'.
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: Yahoo [Bot] and 7 guests