Jump to content

Pulling data from generated text files into Excel


---
 Share

Recommended Posts

I've been tasked with pulling old data from txt or pdf files that pi web have made into one excel file or one report. The person who set the CMM up is no longer around and I can't ask them. I was wondering what the best way to pull the data from those files would be. The CMM class I had didn't cover PiWeb.

Thank you and I'm sorry if this isn't clear, I'm still fairly new to this.
Link to comment
Share on other sites

So I've found out how to organize the files in Excel. I imported the files into a spreadsheet and using the "Text to Columns" button arranged the data. Then I deleted duplicate rows since each part number was unique which got rid of the "END" text and the redundant text I used to make the columns.
Link to comment
Share on other sites

 Share

×
×
  • Create New...