troubleshooting Question

Text file to excel conversion using python

Avatar of Shailesh Shinde
Shailesh ShindeFlag for India asked on
Python
4 Comments2 Solutions3400 ViewsLast Modified:
Hi All,

I have an requirement to convert/extract the contents from the text file into excel file using python script.
input text file format...
1
00:00:04,195 --> 00:00:06,140
This text needs to be extracted.

2
00:00:04,195 --> 00:00:06,140
This text needs to be extracted.

3
00:00:04,195 --> 00:00:06,140
This text needs to be extracted.

.....

and the output excel file format...
Column1  Column2
This text needs to be extracted. This text needs to be extracted.
This text needs to be extracted. This text needs to be extracted.
This text needs to be extracted. This text needs to be extracted.

Can you please suggest the reference or sample code for this.

Thanks,
Shail
ASKER CERTIFIED SOLUTION
Shailesh Shinde
Sr. Project Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros