We help IT Professionals succeed at work.
Get Started

Ading commas to text file

177 Views
Last Modified: 2013-11-26
I have code which opens a text file, which contains many rows of data that look like this:

R3aa12345678c000000032700:006215
R3da87563214c000000606400:007615
R3Ae65987412c000000021100:000715
R3ed32165498c000000336000:005515
R3ac98765432c000000617600:004415
R3aa12345678c000000620601:001315
R3da87563214c000000527201:009915

Each row is 32 bytes long, but I need to add a comma after the 2nd, 12th, 20th, 23rd, 28th, and 30th characters, for each row in the text file.  What would be the best solution for this?  The reason for me wanting to add commas is so that I can then save it as a CSV file, and then import it into a Database.
Comment
Watch Question
High School Computer Science, Computer Applications, Digital Design, and Mathematics Teacher
CERTIFIED EXPERT
Top Expert 2009
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE