I guess since you didn't really give many specifics, nor did you ask an actual question, I'll just say copy and paste the data in your text file into excel.
You don't even need to use csv as long as the formatting is done consistently.
In Excel, go to Data tab, In the Get External Data section, you can choose from text, point to the file and define how the file is formatted for it to be able to split the data into cells.
I've done this exact procedure with Indusoft Web Studio. The issue is that in a recipe data file Indusoft stores arrays of tags that are strings with a space between them and arrays of numbers with linefeeds. If the recipe doesn't have arrays than every line is a separate tag.
So the attached macro for excel in a text file works on four arrays, the first two are strings, the second two are numbers.
The recipe is loading arrays that contain 300 tags.
the indusoft saves data values to a text file. here a snipet of what the text file looks like:
I would like to allow the customer to view this as in a format that makes more sense to them.
Thinking of maybe using the vb in excel to read the lines of the text file and put them in the proper cells? but I don't know how to do that at the moment.
Does Indusoft gives you the option of saving as a .csv file or are you limited to .txt?
A .csv file is also a text file that Excel can open.
If Indusoft won't let you save as .csv, I suggest you create an Excel spreadsheet that displays the data the way you want and then save it as a .csv file. Open the .csv file with Notepad to see how the tagnames and values are arranged. Then modify your Indusoft script to create a file that matches the way the data is presented in the .csv file.
I want excel to read the file, look for ex: "Pre1WashPassSpd" and put it's value in a cell that I made pretty for the customer to see. aka, not display the tag name but something like Easy cleaning: Presoak 1 Wash Pass Speed 1.35 ft/sec. automatically.
Open the text file
Locate the substring "Pre1WashPassSpd="
Extract the characters from the end of that substring until the next CRLF
Convert that to a number and put it into the appropriate cell
Repeat for the next tagname