Most PC's can probably handle Unix text files. What's going on in your case? The main difference is: Unix uses Carriage Return characters (Ascii 13) as end of line markers, and Windows PC's frequently use Carriage Return Line Feeds (Ascii 13 + Ascii 10) as end of line markers - but many programs read both equally well without problems.
I tried to open the unix file and saved it in PC text format but it resulted to having rubbish characters. This is not what I wanted. I want my macro to do is to convert the unix file to pc readable file first before doing string manipulation, etc. I hope you could help me. Thanks in advance.
I'm off for a little while.
You may find it useful to download Notepad++ (freeware). It's a very good cross-platform editor, and, if you can read your file at all, you can read it there (as well as perform conversions). It may help you to understand what you are dealing with better.
As I've said, as far as I know Unix text files are normally not a problem for Excel/Windows - where is this file coming from and what kind of data is in it?
The file is coming from a Linux based operating system. I can read the file in textpad but I don't want to do that. What I want to do is insert the conversion script in my code so I don't have to do it manually.