Friday, July 21, 2006 4:43 PM
I need urgently in my job to converfile to .DAT file?
Can some one help on the same.
Wednesday, July 26, 2006 9:07 AM
Please elaborate on the .DAT file, ie format, which application will use it etc
Monday, July 31, 2006 8:18 PM
Here here...I need to do the same thing. I have Excel files I've saved as .csv delimited files. The files are pipe-delimited but I don't have a pipe-delimit extension.
I need to get these files saved with .dat extension. I am copying them to an FPT location where another person is grabbing. them. They need data files with .dat extensions. I believe their scripts looks for these automatically.
I have not found yet a method to convert .xls to .dat.
Tuesday, August 01, 2006 3:29 AM
Nothing magic about pipe-delimited format. It's text, with entries separated by a pipe (vertical line character) within a record, and by carriage returns between records. Here's a nice explanation of the process, with some code examples:
There are a few utilities that will save a worksheet as pipe-delimited:
To find things like this, you can use Google. "Excel export pipe delimited".
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Friday, August 11, 2006 9:48 AMI've just had the exact same problem and Googled an answer.
You cannot configure Excel but have to configure Windows.
"Start -> Settings -> Control Panel -> Regional Settings."
"Start -> Settings -> Control Panel -> Regional and Language Options."
Click "Customize" then change "List Separator" to the pipe character.
In excel select "File -> Save As" and choose CSV.
The registry key for this is
HKEY_CURRENT_USER\Control Panel\International --> sList
Friday, October 31, 2008 7:07 PM
Save your excel file as a .txt file. U may get some error messages-ignore them. Rename the extension .txt to .dat This again may give you a few error messages-ignore them.
If you open the .dat file you will see all the coordinates you had in the excel spreadsheet.
In Unigraphics to create a spline import the .dat file.
I hope this helps.