Excel Mac 2008 Worksheet Export Text File With Semicolon Delimiter

I have a worksheet that I have been given that uses tabs for delimiters.  My update script needs it to have a delimiter as a semi colon instead.  Please tell me how to export to a .txt file with a semicolon as a delimiter.

Thanks,

Randal
sharingsunshineAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
strungConnect With a Mentor Commented:
I don't quite understand your question. Excel itself does not use tabs as delimiters. Do you mean you were given a tab delimited text file that you want to convert to a semicolon delimited text file?

If so, the easiest thing to do is to download a free copy of TextWrangler ( http://www.barebones.com/products/textwrangler/download.html ), and use its global search and replace to replace all tabs with semicolons.
0
 
sharingsunshineAuthor Commented:
the how to geek article is for Windows Excel.  I found that article before I ever posted the question.  Additionally, the save as opiton on my Excel doesn't have the "Other Formats" option.  Although, it is a great article for a Windows user.

I received a .xls worksheet that is tab delimited.  Since it is in a .xls format TextWrangler isn't allowing me to the see the data.  So, you mentioning the TextWrangler option gave me the idea to export it as .csv then use TW to change them to semicolons.

Since neither of you had the complete answer I have decided to split the points.

Thanks,

Randal
0
 
sharingsunshineAuthor Commented:
Thanks for both of your answers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.