MSDOS / Output needed in a new line / Batch File

Well as long as i can get an output file with presentable data without having to sift through, i can explore that. But it has to be simple method.  

Where do i start from  ? and What should i do ?

Well, what's the 'normal' approach here?

It sounds like from your prior question that the batch/script can get moved around a lot - not only within folders, but across machines as well.

Perhaps outline the process a bit more.  Hopefully I can get a better handle on it.
For example, if you want to process all files in a given folder, that's a cinch...
If you wanted to use the same script each time, but simply supply a in & out list
(i.e
newyork=usa
moscow=russia
etc

we could have the script read that 'setup' file and then import the left part of the line (newyork) and export it to the (usa) right part...

Could you also detail 'script' a bit more?  Is that all it's doing is parsing this data for you from another file?  Perhaps one devised script here could eliminate that process?  

I don't suppose you could modify your batch file to output the data to *.txt file rather than *.xls and then upload a sample of it here for us to inspect?

script  1.11.111.111 <input1.txt>output1.txt

If the data is confidential, then obviously that's out of the question, but I'm curious to see what those characters are.

Let me go in a little detail. The script files can be moved around the computers, folders and probably even be distributed [this is highly unlikely but it will depend on the management people].

The device i am working on is an electronic device. It uses modbus protocol for communication.
http://www.modbus.org/ . Our limitation on the number of register addresses is 65000.

I test this device using scripts. I write to this device and read from htis device. I also use third part equipment which changes the values in those modbus register. This device comes with their properirtary software. I cannot test this device without this hardware and software.

Now to do a complete test cycle for one device in the development stage requires minimum 4 months. If i write these scripts which run in conjunction with the third part hardware and software, the same can be done in less than 7 days.

The amount of data that will be needed to be analyzed will be huge. I need my output files in a presentable format as i explained in the screenshot.

The input file contains commands that write to the device. The device is set.  I control the hardware with the software from my computer. The software calls the batch file in between tests and writes to the device.

After the test is completed i need to read from the device which is then stored in the output file. I enter this further into detailed test procedures.

The following type of data exists:
 Character
 Word
 Hexadecimal
 Long
 Float

I hope this helps.

Bill

I have already posted the screenshot of the excel file output and the text file output above. A  pdf file is also attached with the ASCII codes.

Hi iceb.

My problem with taking this further is that a pdf print of the text output (presumably from notepad) and a screenshot of the excel file can't be analysed in its native format.  All they do is show what the files look like.  I was interested in the actual file.  I already know the ASCII table.

The characters are obviously acting as end of line characters, or more correctly new line characters.  DOS Text (ASCII) uses the control characters Carriage Return and a Line Feed (CR,LF = 0D,0A hex), while Unix text uses only a LF.  I believe Macintosh uses only a CR, but I may be wrong about that.

That's my reason for wishing to analyse the actual file.

Bill

I am sorry i misunderstood your request earlier. I can send you the files but i can't post them here. I would still have to change the data in them for properietary reasons.

If you can put your email in your member profile i can send the text file output and excel file output to you on Monday.

Ice B.