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
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Excel 2008 for mac question


Post Reply New Thread Subscribe

 
Thread Tools
springville pop

 
Member Since: Aug 17, 2010
Posts: 5
springville pop is on a distinguished road

springville pop is offline
Hello,
I'm in the process of moving from a PC to an iMac. I upload an Excel file to my shopping cart in tab delimited format. Worked fine on the PC. On the mac it's not putting an end of line character in the tab delim. file. Comes across as one long line instead of almost 2000 lines. Anyone know how to get the CR or what ever other symbol is needed at the end of each line?

Thanks in advance for any advice.
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 39,375
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
Upload an Excel file to your shopping cart? Sounds like you're buying it. Are you saying that you're trying to open an Excel file from Windows on your Mac using Excel from Office 2008? And the file was saved as tab delimited?

Tab delimited format displays like plain text. There's no guaranty of compatibility when saving that way. As a matter of fact, delimited format is generally used when there is no compatibility between programs. Which is one reason many banks use it as a download option for their users to fill in accounts. Is there any reason it can't be saved as a normal Excel file?

Regards.
QUOTE Thanks
springville pop

 
Member Since: Aug 17, 2010
Posts: 5
springville pop is on a distinguished road

springville pop is offline
No, it's my shopping cart and the database file I'm trying to upload contains all the products on my site. The cart uses it as my product database. It has to be uploaded in some kind of delimited format. It can be tab, or , or | but not as an Excel file. My Windows Excel sent it correctly. When I saved it as a tab delimited file on the mac I got the problem Got the same problem when I tried a , delimited file. Looked back at the save form and didn't see any variables that could be changed.
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 39,375
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
OK, I understand what you're trying to do, but the answer is going to be the same. It's a common problem with CSV and delimited files especially when moving them between operating systems. Best I can suggest is to experiment with the file format to see if it will you can get it to save correctly on your Mac. Otherwise you might be stuck with manually placing the EOL marker at the end of each line in order to break it down to the right format.

Regards.
QUOTE Thanks
springville pop

 
Member Since: Aug 17, 2010
Posts: 5
springville pop is on a distinguished road

springville pop is offline
OK. It would be easy to add the EOL marker at the end of each line in my file. But I have a dumb question...what is the EOL marker?

Thanks!
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 39,375
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
EOL is what's known as a carriage return. You've got a lot of work ahead of you if that file is actually a 2000 line data base. Hitting return that many times is no fun. You need to find a better way of uploading that file to the shopping cart. How about MS Office 2008 for the Mac? Do you have a copy? If not, you can try the free Open Office for the Mac. File compatible with MS Office for Win and Mac.

Regards.
QUOTE Thanks
springville pop

 
Member Since: Aug 17, 2010
Posts: 5
springville pop is on a distinguished road

springville pop is offline
Yes, I have MS Office 2008 for the mac. That's the Excel program that I keep the file in, saving as a tab delimited before uploading. If it would see the CR I could enter it in my last column. It's just a letter N so N{CR} would not be hard to copy/past down the line. If it would go into the tab delimited file OK.

Thanks for your help. I appreciate it!

I tried putting a command return after the N in the last column. Didn't work. I'm new to the mac...I'm assuming (that can get me into trouble) that command return would be the same as control return in windows.
QUOTE Thanks
springville pop

 
Member Since: Aug 17, 2010
Posts: 5
springville pop is on a distinguished road

springville pop is offline
Problem solved! Excel for mac Office 2008 doesn't save as a tab delimited file well. Saved file as "Windows formatted text file". Worked fine then.

Thanks for all the help!
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 39,375
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
Thanks for posting back. We both learned something...

Regards.
QUOTE Thanks

Post Reply New Thread Subscribe


« transfer from Mail to iCal? | Dashboard not functioning »
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
Visual Basic - Microsoft Excel 2008 For Mac - Help! lovinthemac OS X - Apps and Games 4 05-25-2010 05:44 PM
Excel Question dhyde Running Windows (or anything else) on your Mac 1 08-16-2009 04:25 PM
Excel 2008 - Issue Creating Charts TheAlmightySam OS X - Apps and Games 0 03-25-2008 12:41 AM
Crazy Mac Excel Question tbgiles OS X - Apps and Games 5 03-04-2007 08:11 AM

All times are GMT -4. The time now is 03:51 AM.

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?