I’m trying to set a variable and write to a file the value of the last occurrence of ‘time=’, 00:24:53.16, in this example file.<\/p>\n
——– file: input.txt ——–
\nInput #0, mp3, from ‘test.mp3’:
\nMetadata:
\nencoder : Lavf57.51.102
\nDuration: 00:23:41.31, start: 0.025057, bitrate: 128 kb\/s
\nStream #0:0: Audio: mp3, 44100 Hz, stereo, s16p, 128 kb\/s
\nMetadata:
\nencoder : Lavc57.60
\nOutput #0, null, to ‘pipe:’:
\nMetadata:
\nencoder : Lavf57.51.102
\nStream #0:0: Audio: pcm_s16le, 44100 Hz, stereo, s16, 1411 kb\/s
\nMetadata:
\nencoder : Lavc57.60.101 pcm_s16le
\nStream mapping:
\nStream #0:0 -> #0:0 (mp3 (native) -> pcm_s16le (native))
\nPress [q] to stop, [?] for help
\nsize=N\/A time=00:03:29.65 bitrate=N\/A speed= 419x
\nsize=N\/A time=00:07:56.65 bitrate=N\/A speed= 477x
\nsize=N\/A time=00:12:25.43 bitrate=N\/A speed= 497x
\nsize=N\/A time=00:16:56.45 bitrate=N\/A speed= 508x
\nsize=N\/A time=00:21:22.56 bitrate=N\/A speed= 513x
\nsize=N\/A time=00:24:53.16 bitrate=N\/A speed= 515x
\nvideo:0kB audio:25720kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: unknown
\n——– end of file ————<\/p>\n
The trouble I’m having comes from the fact that all the ‘lines’ starting with ‘size=’ (except the last one) end with <sp><sp><sp><sp><cr>, no <lf>, so they are really part of a single line as far a parse-ability is concerned. The last ‘size=’ line has a <cr><lf>.<\/p>\n
So, the problem really boils down to extracting the last of several occurrences of a string in a line of unknown length, e.g.:<\/p>\n
size=N\/A time=00:03:29.65 bitrate=N\/A speed= 419x size=N\/A time=00:07:56.65 bitrate=N\/A speed= 477x size=N\/A time=00:12:25.43 bitrate=N\/A speed= 497x size=N\/A time=00:16:56.45 bitrate=N\/A speed= 508x size=N\/A time=00:21:22.56 bitrate=N\/A speed= 513x size=N\/A time=00:24:53.16 bitrate=N\/A speed= 515x<\/p>\n
In case it makes the solution any easier, the desired ‘time=’ value will always be the last one in the file, and will always be the ‘largest’.<\/p>\n
The following batch file almost works, but it finds and processes the first ‘time=’ value, not the last. It converts the value to seconds, strips the echo-added <cr><lf>, sets an environment variable, and sends the result to a file. It works except on the wrong data. Is there some way to accomplish this in a pure Win batch file?<\/p>\n
@echo off
\nfor \/F “tokens=1-7 delims==:. ” %%1 in (input.txt) do (if “%%1″==”size” call :findtime %%4 %%5 %%6 %%7)
\n:findtime
\necho:
\nset \/A s=%3 & set \/A s=s+%2*60 & set \/A s=s+%1*60*60
\necho:%1:%2:%3.%4 = %s%.%4 seconds
\nset dur=%s%.%4
\necho:%dur% = includes a CRLF
\n<nul (set\/p z=%dur%)
\necho: = stripped CRLF, method1
\n(echo:|set \/p =”%dur%”)>duration.txt %= strip CRLF then send to file for later use =%
\ntype duration.txt
\necho: = stripped CRLF, method2
\necho:
\npause<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":17},"question-category":[55],"question_tags":[],"class_list":["post-8103","question","type-question","status-publish","hentry","question-category-programming"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/8103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=8103"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=8103"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=8103"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=8103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}