Python Forum
How to convert .trc/.txt file into excel using python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to convert .trc/.txt file into excel using python
#1
I want to convert .trc file (image 1) into excel(image 2). Once it is converted to excel I want a command prompt to open up asking 'Select the model to be analyzed' with options of '1. 18FFFF20 2.18FFFF80 3.18FFFF81'(this data stats from column E row 15, refer image 2). Once the desired model is selected(by typing '1' '2' or '3' in the command prompt), I want to convert the filtered hex data (starting from column G to column N in image 2) into decimal data(image 3). I want it as an application form. I am totally new to python so don't know how to code😅

update: I am able to make and application but I'm having trouble converting .trc(image 1) file into csv(image 2)

Attached Files

Thumbnail(s)
           
Reply
#2
please make an effort to write the code.
Then show what you have working or not and ask questions about problem areas.
Please read: https://python-forum.io/misc.php?action=help&hid=52
Reply
#3
(Jan-15-2023, 10:02 PM)Larz60+ Wrote: please make an effort to write the code.
Then show what you have working or not and ask questions about problem areas.
Please read: https://python-forum.io/misc.php?action=help&hid=52

The thing is I'm totally new to python. I have little to no knowledge sadly.
Reply
#4
You can start by learning the basics https://docs.python.org/3/tutorial/index.html
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Excel File reading vanjoe198 1 2,026 Mar-31-2021, 11:53 AM
Last Post: snippsat
  Convert all actions through functions, fill the dictionary from a file Astone 3 2,414 Oct-26-2020, 09:11 AM
Last Post: DeaD_EyE
  How can I convert specific rows from excel to pandas dataframe? mcva 1 1,797 Apr-20-2020, 09:14 AM
Last Post: pyzyx3qwerty
  Read directly from excel file using python script dvldgs05 0 2,250 Oct-19-2018, 02:51 AM
Last Post: dvldgs05
  Python code to convert executable file to doc or pdf Micmilli2 3 2,958 Oct-11-2018, 10:15 AM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020