Microsoft Office Questions? Ask a IT Expert for Support ASAP
Welcome to JustAnswer. My name is XXXXX XXXXX I will be assisting you today. Please do not rate this session until it has been completed.
You would need to tell Excel that the data being imported is a string value. The easiest way to do that would be to insert quotes before and after each number.
I will try and advise.
Ok. Let me know if you run into any troubles.
I may have more question on this later
Help. Need a script that can be used to repeatedly convert a fixed length field file to a tab delimited file. Once you respond I will send 3 files. I plan to upload the 3 files below to wikisend for you to download and use to create the script that can run on my laptop and eventually a win 2008 server. The 3 files to be sent are: 1. an instance of the fixed length file that needs to be parsed 2. the file layout document showing the length of each feild 3. the result desired - a tab delimited text file. I need a process that can be used over and over to convert the same fixed lengthed file format to the desired tab delimited result. Thanks. Jerry
Here are the links to the files:
http://wikisend.com/download/409432/desired resulting file.txt