[RESOLVED] [Help] replace within a .txt; column value against another column

hayato1

Hi all i wanna start but i don't know where to start,
can you guys guide me?

i got some trouble in a flat text file (SST) subtitle file for DVD

it looks like this upto hundreds or thousands lines

st_format	2
Display_Start	non_forced
TV_Type		NTSC
Tape_Type	NON_DROP
Pixel_Area	(0 477)
Directory	C:\Documents and Settings\Administrator\Desktop\New Folder\
Subtitle	DVD1tc
Display_Area	(0 2 719 479)
Contrast	(15 15 15 0)

#
# Palette entries:
#
# 01 : RGB(255,255,255)
# 02 : RGB(  0,  0,  0)
# 03 : RGB(252,250,255)
# 04 : RGB(255,255,128)
# 05 : RGB(255,  0,128)
# 06 : RGB(  0, 64,128)
#

PA	(0 0 255 - - - )
E1	(255 0 0 - - - )
E2	(0 0 0 - - - )
BG	(255 255 255 - - - )


SP_NUMBER	START	END	FILE_NAME
Color	(2 1 1 1)
0001	00:00:15:04	00:00:16:13	DVD1tc_0001.bmp
0002	00:00:17:26	00:00:20:15	DVD1tc_0002.bmp
0003	00:00:22:00	00:00:23:11	DVD1tc_0003.bmp
..........
........
0046	00:02:56:27	00:02:57:21	DVD1tc_0046.bmp
Color	(5 4 3 1)
0047	00:02:57:21	00:02:59:01	DVD1tc_0047.bmp
0048	00:02:59:01	00:02:59:25	DVD1tc_0048.bmp
0049	00:02:59:25	00:03:00:25	DVD1tc_0049.bmp
Color	(5 3 3 1)
0050	00:03:00:25	00:03:00:26	DVD1tc_0050.bmp
Color	(5 4 3 1)
0051	00:03:00:26	00:03:02:14	DVD1tc_0051.bmp
0052	00:03:02:14	00:03:02:20	DVD1tc_0052.bmp
0053	00:03:02:20	00:03:05:01	DVD1tc_0053.bmp
Color	(5 3 3 1)
0054	00:03:05:01	00:03:05:06	DVD1tc_0054.bmp
Color	(5 4 3 1)
0055	00:03:05:06	00:03:06:03	DVD1tc_0055.bmp
0056	00:03:06:03	00:03:06:15	DVD1tc_0056.bmp
0057	00:03:06:15	00:03:07:06	DVD1tc_0057.bmp
0058	00:03:07:06	00:03:08:07	DVD1tc_0058.bmp

because dvd authoring program is missing function for each other,
that makes alot of manual editing require for compatibilty every time I used.

Below Picture is original MaestroSBT output

require to be this after checking if any END = START; SET END "-"
to cleanup bug for flickering subtitle to Muxman input

is this possible to do within PHP or anything else, i have no idea where to start but i hope can get job done, so that i no need few hours editing them everytime.

can you please help me?
Thanks~

bradgrafelman

EDIT: Hmm.. normally I don't hand out code, but I thought I'd give this a shot. Here's what I came up with:

$pattern = '/([0-9]{4}\s+(?:(?:[0-9]{2}\:){3}[0-9]{2}\s+){2}[a-z0-9\.\_\-]+)/si';

preg_match_all($pattern, $content, $matches);

if(empty($matches[1]))
	die('Invalid file format - couldn\'t find SP_NUMBER data.');
else {
	$matches = $orig_data = $matches[1];
	array_walk($matches, create_function('&$value', '$value = preg_split(\'/\s+/\', $value);'));
}

for($i=0,$max=count($matches); $i<$max; $i++) {
	if(($i+1) < $max && $matches[$i][2] == $matches[$i+1][1])
		$matches[$i][2] = "-\t";
}

array_walk($matches, create_function('&$value', '$value = implode("\t",$value);'));

$content = str_replace($orig_data, $matches, $content);

hayato1

thanks alot bradgrafelman, it work like what i wanted exactly!!!!!!!!!!!!!
really so thanks you!!!!!!

the script is really going to save me ALOT of time!!!!!!!!
approximate each sst requires aleast like 1 hour checking normally
now it only takes 1 sec!!!!!!

thanks again