New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Web Design and Hosting Creating sites, scripting, and hosting discussions.

OS 10.4 - import online text in .csv format


Post Reply New Thread Subscribe

 
Thread Tools
schwine

 
Member Since: Dec 12, 2005
Posts: 68
schwine is on a distinguished road

schwine is offline
I am trying to import a list of words from an online web page using a .csv (comma separated value) import option on the web page.

When I click on the .csv option on the web page, I have tried to import the text with various software, including TextEdit, TextWrangler, and Microsoft Word and Excel for Mac. Both Word and Excel offer .csv support but I have not been able to import the text list in the desired fashion.

Here is how the text currently imports (vertical arrangement):

word1
word2
word3

Here is how I need the text to import (horizontal arrangement with commas):

word1,word2,word3

Any tips on how I can import text in the desired horizontal fashion are greatly appreciated.
QUOTE Thanks
xstep

 
xstep's Avatar
 
Member Since: Jun 25, 2005
Location: On the road
Posts: 3,231
xstep is a name known to allxstep is a name known to allxstep is a name known to allxstep is a name known to allxstep is a name known to allxstep is a name known to allxstep is a name known to all
Mac Specs: 2011 MBP, i7, 16GB RAM, MBP 2.16Ghz Core Duo, 2GB ram, Dual 867Mhz MDD, 1.75GB ram, ATI 9800 Pro vid

xstep is offline
I can't say 'for sure', but it sounds like the csv file is not set up correctly. Or you are expecting something from what the creator intended. If you think the csv file is wrong, contact the creator.

A simple way to check it is to open up Terminal.app, type the word, cat, at the command line and drag the file to the terminal window, then hit the return key. If you get what you have described, a word per line, then there are inappropriate end of line characters after each field. The only way I can think to fix that is to write a script.

Perhaps Excel has a custom import option. Maybe TextWrangler has the ability to create a repetitive macro.

If the number of words per row are exactly the same, then a script is easy enough to write. If the number of words vary, then one needs to know the data to have a chance to fix it.
QUOTE Thanks
schwine

 
Member Since: Dec 12, 2005
Posts: 68
schwine is on a distinguished road

schwine is offline
The text on the web page is arranged in a single column of words (top to bottom), so perhaps the .csv file is just following this arranged format of the words from the web page. So I'm importing these words or short phrases (1-3 word strings) that appear as a list on the web page.

Perhaps the best way to illustrate this is to visit the web page I'm dealing with. The web page address is below, but takes a quick explanation as to how to create the .csv download option.

Once the user has reached the web page, there is a blank box into which the user types any word or phrase, like "receipes", "car mechanics" or "spring fashions" (type without quotes). Then a list of complimentary words appear related to that original word or phrase. On the right hand side of the word list is an "add" link that allows the user to add the words to a "selected keywords" list on the right hand side of the screen. For the purposes of a test, a user could just add the top 3-4 words or phrases.

Now the .csv option is functional, and also appears on the right hand side of the screen, along with the selection of words or phrases to import.

Here is the web page address:

https://adwords.google.com/select/KeywordToolExternal
QUOTE Thanks
xstep

 
xstep's Avatar
 
Member Since: Jun 25, 2005
Location: On the road
Posts: 3,231
xstep is a name known to allxstep is a name known to allxstep is a name known to allxstep is a name known to allxstep is a name known to allxstep is a name known to allxstep is a name known to all
Mac Specs: 2011 MBP, i7, 16GB RAM, MBP 2.16Ghz Core Duo, 2GB ram, Dual 867Mhz MDD, 1.75GB ram, ATI 9800 Pro vid

xstep is offline
Looking at the page result and the csv file, I'd say they match. The words are in one column in both. You'll need to write a script to separate them further.
QUOTE Thanks

Post Reply New Thread Subscribe


« IWEB TEMPLATES - ilifestuff.com | need more diskspace for .mac iDISC! »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Open Letter to Apple Saint Mark Switcher Hangout 23 08-15-2006 03:15 AM
Any other format than m4p from iTunes Music Store? rcltrh iPod Hardware and Accessories 3 04-14-2006 06:43 PM
text reflow problems from Quark 4.1 to Quark 6.5 plevault13 Running Windows (or anything else) on your Mac 2 09-30-2005 02:59 PM
text reflow problems from Quark 4.1 to Quark 6.5 plevault13 OS X - Apps and Games 0 09-30-2005 01:57 PM
Format Flash Card PowerbookG417 Archival Forum 1 04-26-2004 11:21 AM

All times are GMT -4. The time now is 08:40 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?