viaaa
02-24-2016, 03:35 PM
Hi,
I exported an excel sheet into txt file, then changed the file extension from txt to dat. I opened the dat file in windows and everything looked good. Below how it looks like.
:Product Code: 0xfaa
:Magic Number: 0xfaa1
:Version Num : 0xd
#
Date : 7/7/2014
DEFAULT 50
#
HIGH (75) 0 0 0.4 0.4 0.8 0.6 0.4 1.2 1.4 1.4 1 1 0.8 1.6 0.6 0.8 1 1.8 1.1 3.5 2.2 0.8 0.5 0.6 1 0.6 1.6 1 0.6 0.8 1 2.4 2.7 1.8 1.1 1.3 2.2
MEDIUM (50) 0 0 0.3 0.3 0.7 0.5 0.3 1 1.2 1.2 0.8 0.8 0.7 1.3 0.5 0.7 0.8 1.7 1.1 3.4 2.1 0.8 0.5 0.6 0.9 0.6 1.5 0.9 0.6 0.8 0.9 2.3 2.6 1.7 1.1 1.2 2.1
LOW (25) 0 0 0.3 0.3 0.6 0.5 0.3 0.9 1.1 1.1 0.8 0.8 0.6 1.2 0.5 0.6 0.8 1.5 1 3.1 1.9 0.7 0.4 0.6 0.8 0.6 1.4 0.8 0.6 0.7 0.8 2.1 2.4 1.5 1 1.1 1.9
END_HISTORICAL_POPUPS
I need to read the dat file into a simulation tool in a linux machine. The weird thing is, if I open the same dat file in Linux, the file format changes and can't be read successfully into the simulation tool. Below is how it looks like if opened in linux.
:Product Code:
0xfaa
:Magic Number:
0xfaa1
:Version Num :
0xd
#
Date :
7/7/2014
DEFAULT
50
#
HIGH (75) 0 0 0.4 0.4 0.8 0.6 0.4 1.2 1.4 1.4 1 1 0.8 1.6 0.6 0.8 1 1.8 1.1 3.5 2.2 0.8 0.5 0.6 1 0.6 1.6 1 0.6 0.8 1 2.4 2.7 1.8 1.1 1.3 2.2
MEDIUM (50) 0 0 0.3 0.3 0.7 0.5 0.3 1 1.2 1.2 0.8 0.8 0.7 1.3 0.5 0.7 0.8 1.7 1.1 3.4 2.1 0.8 0.5 0.6 0.9 0.6 1.5 0.9 0.6 0.8 0.9 2.3 2.6 1.7 1.1 1.2 2.1
LOW (25) 0 0 0.3 0.3 0.6 0.5 0.3 0.9 1.1 1.1 0.8 0.8 0.6 1.2 0.5 0.6 0.8 1.5 1 3.1 1.9 0.7 0.4 0.6 0.8 0.6 1.4 0.8 0.6 0.7 0.8 2.1 2.4 1.5 1 1.1 1.9
END_HISTORICAL_POPUPS
I don't know why this happens and how I can fix the problem. Any suggestions are appreciated!
I exported an excel sheet into txt file, then changed the file extension from txt to dat. I opened the dat file in windows and everything looked good. Below how it looks like.
:Product Code: 0xfaa
:Magic Number: 0xfaa1
:Version Num : 0xd
#
Date : 7/7/2014
DEFAULT 50
#
HIGH (75) 0 0 0.4 0.4 0.8 0.6 0.4 1.2 1.4 1.4 1 1 0.8 1.6 0.6 0.8 1 1.8 1.1 3.5 2.2 0.8 0.5 0.6 1 0.6 1.6 1 0.6 0.8 1 2.4 2.7 1.8 1.1 1.3 2.2
MEDIUM (50) 0 0 0.3 0.3 0.7 0.5 0.3 1 1.2 1.2 0.8 0.8 0.7 1.3 0.5 0.7 0.8 1.7 1.1 3.4 2.1 0.8 0.5 0.6 0.9 0.6 1.5 0.9 0.6 0.8 0.9 2.3 2.6 1.7 1.1 1.2 2.1
LOW (25) 0 0 0.3 0.3 0.6 0.5 0.3 0.9 1.1 1.1 0.8 0.8 0.6 1.2 0.5 0.6 0.8 1.5 1 3.1 1.9 0.7 0.4 0.6 0.8 0.6 1.4 0.8 0.6 0.7 0.8 2.1 2.4 1.5 1 1.1 1.9
END_HISTORICAL_POPUPS
I need to read the dat file into a simulation tool in a linux machine. The weird thing is, if I open the same dat file in Linux, the file format changes and can't be read successfully into the simulation tool. Below is how it looks like if opened in linux.
:Product Code:
0xfaa
:Magic Number:
0xfaa1
:Version Num :
0xd
#
Date :
7/7/2014
DEFAULT
50
#
HIGH (75) 0 0 0.4 0.4 0.8 0.6 0.4 1.2 1.4 1.4 1 1 0.8 1.6 0.6 0.8 1 1.8 1.1 3.5 2.2 0.8 0.5 0.6 1 0.6 1.6 1 0.6 0.8 1 2.4 2.7 1.8 1.1 1.3 2.2
MEDIUM (50) 0 0 0.3 0.3 0.7 0.5 0.3 1 1.2 1.2 0.8 0.8 0.7 1.3 0.5 0.7 0.8 1.7 1.1 3.4 2.1 0.8 0.5 0.6 0.9 0.6 1.5 0.9 0.6 0.8 0.9 2.3 2.6 1.7 1.1 1.2 2.1
LOW (25) 0 0 0.3 0.3 0.6 0.5 0.3 0.9 1.1 1.1 0.8 0.8 0.6 1.2 0.5 0.6 0.8 1.5 1 3.1 1.9 0.7 0.4 0.6 0.8 0.6 1.4 0.8 0.6 0.7 0.8 2.1 2.4 1.5 1 1.1 1.9
END_HISTORICAL_POPUPS
I don't know why this happens and how I can fix the problem. Any suggestions are appreciated!