I usually use Excel to open a text file with csv format where each information is separated by comman (or other delimitor). When I open the file with Excel, i will be asked what kind of delimitor i would like to apply, then Excel will display the content correctly.
However, it does not work the same for OpenOffice. It just open the file with Word prcessor (Write). Is there a way I can force OppenOffice to do the same as that of Excel.
Example of my file
Name | Phone | Zip
John | 323-4345 | 35445
Tim | 234-2342 | 23434