CSV file. Frustrated!

Masterptc

Masterptc

Regular Member
Joined
Aug 9, 2011
Messages
421
Reaction score
603
Im very frustrated and i cant figure this out, maybe someone here can help me and end my frustration and earn a Thanks. :)
Im scraping shipping info from a website, the shipping info isnt being separated correctly because there is no deliminator after "CA" as shown in the pic below. How the hek do i get it to add a deliminator without doing it manually?

Screen_Hunter_263_Sep_29_05_21dsds.jpg
 
Advertise on BHW
It depends on how your CSV file is setup in the first place, but by the looks of what you have there.. I'd import it as is, then after you've got your data in Calc:

Highlight the column you want to split
Goto the "Data" menu and select "Text to Columns"
On the popup window, select the "Space" option in the Separated by section
And you're done.
 
copy all the "CA Zipcode" things
paste in notepad
press tab once, block the tab and ctrl + x
Ctrl+h
replace the space with tab [ctrl+v] (it's in the clipboard)
copy paste back to excel
now it's separated
 
madandi said:
It depends on how your CSV file is setup in the first place, but by the looks of what you have there.. I'd import it as is, then after you've got your data in Calc:

Highlight the column you want to split
Goto the "Data" menu and select "Text to Columns"
On the popup window, select the "Space" option in the Separated by section
And you're done.
Click to expand...
It would be easier to add a comma to it by editing in a notepad file, is there a way i can create a custom deliminator for all 50+ US states?
 
If the name, address and city are all coming out in Column A, and the state and zip in Column B (like in your screenshot), then following the steps I suggested above will have that data separated in 2 seconds flat without the need to go back and forth between notepad, and trying to figure out a tricky way to insert a comma after 50 different states.
 
madandi said:
If the name, address and city are all coming out in Column A, and the state and zip in Column B (like in your screenshot), then following the steps I suggested above will have that data separated in 2 seconds flat without the need to go back and forth between notepad, and trying to figure out a tricky way to insert a comma after 50 different states.
Click to expand...
Except i scrape new data everyday, and im trying to have everything run without me going back into the files and making changes.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top