DataMystic

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?

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'.