AutoHotkey Community

[Zvi]

I have text files that look like this: (They are chapter ponts exported from a video editing program)

1,"00:00:00:00","Clip"
2,"00:04:20:17","Mifgash"
3,"00:05:50:14","Siyur"
4,"00:08:23:02","Promo"
5,"00:11:49:11","Hall"
6,"00:14:55:23","Ketuba"
7,"00:16:18:22","Hupa"
8,"00:19:18:19","NULL"
9,"00:22:28:03","Kenissa - Dance 1"
10,"00:27:36:00","NULL"

Sometimes these files can have 3 lines and sometimes over 40.

I recorded a "copy\paste" of each time code and pasted them into Adobe Encore DVD and created a chapter in Encore DVD.

When running the script, it works like a charm. (Adobe Encore doesn't allow importing chapters from other programs so this is a big time saver for me)

My question is, how do I get the AutoKey script to detect the last line in the text file and stop the script? (I would then record a 50 line text file (the most I ever need) and the script would go through the lines until the last line and stop.

Or better yet, is there a way to have the script just detect the charachters inside the quotations (e.g. 00:05:50:14 ) (I don't need to copy\paste any of the rest) so I only have to record ONE line and have the script loop until it detects there are no more lines?

Thanks

[HugoV]

1) Look into Loop, parse file, it will automatically stop at the last line.
2) You could lookinto RegExMatch, but if you find that difficult you could
StringGetPos to get the position of the first " and then use StringMid
to "cut" the string you need.

Try the loop and String method, post the code you have if you
can't get it to work.
_________________
When parsing a CSV file use Loop, parse, Inputvar, CSV!

[SKAN]

if you are using FileReadLine, you can check the Errorlevel and Break.


_________________

[Zvi]

It says that the characters \.*?+[{|()^$ must be preceded by a backslash.

Since my file is like this:

1,"00:00:00:00","Dance 1"
2,"00:12:54:21","Hina"
3,"00:34:30:21","Dance 2"
4,"01:21:05:02","NULL"

All I need is the 00:12:54:21 from each line.

I tried
Loop, FileRead ,chapters, %A_Temp%\002.csv
{
Loop, parse, A_LoopReadLine, %A_Tab%
{
FoundPos := RegExMatch(chapters, ".+", chapters)
MsgBox, %chapters%
}
}

and
FoundPos := RegExMatch(chapters, \".+\", chapters)

but I can't figure it out. I think I'm getting it all wrong.

How can I loop through the above text and get only the timecode copied to the clipboard?

thanks

[Sivvy]

[Zvi]

Thanks for the reply.

All it does is create a new file for PathAndNameOfFileToWriteTo but it's an empty file.

Also, I don't want to create a new file, I just want to copy the timecodes (e.g. 00:01:22:03) to the clipboard.

[Sivvy]

Did you change the names like I said at the bottom of my post? It's not going to read from a file that doesn't exist.

[Zvi]

Yes I did. I'll try it again.

To those who worte about StringGetPos, this would work:

Loop, read, C:\002.csv
{
Loop, parse, A_LoopReadLine, %A_Tab%
{
StringGetPos, pos, A_LoopField, " ; [, , 3] for second one
if pos >= 0
MsgBox, The string was found at position %pos%.
}
}

but I don't need this because my two (") characters are ALWAYS at position 2 and 14. Now I just need to know how to get the timecode inbetween them into the clipboard so I can have the script paste them somewhere else.

[Zvi]

I tried


Loop, Read, C:\002.csv
{
StringSplit, FullString, A_LoopField, "
FileAppend, %FullString2%, C:\008.csv
}

But 008.csv just is empty.

[Slanter]

[Zvi]

These both worked great!!

Thanks so much!