View Single Post
 
Old 07-25-2024, 12:41 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The link you posted to the other forum isn't working so I don't know if the problem is the link or the site itself.

You've made a dummy file as a sample and it may or may not relate to the real life files you deal with so I'm not going to waste time with code that might work. But I will describe a non-coded way to approach this problem - this non-coded method could actually be a similar process that a macro could work.

1. Select the text at the top (before the timestamps begin) and convert it to a table, separated at paragraphs and 2 columns. Then insert 2 columns to the left.
2. With the timestamped text, you could do a similar method although you will need to first insert empty paragraphs where there isn't a second paragraph under a timestamp.
3. Then you could paste the two columns from the timestamps into the extra two columns you added in Step 1.
Assuming all that lines up correctly, you can convert the table back to text and the job is done.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote