From: Adam Teale <ateale@...>
Date: 2006-12-06T17:52:18+09:00
Subject: Re: Newbie: working with a text file and converting to xml

Hi Kev & Peter!

Thanks for respoding so quickly!

The text file looks pretty much like that

00:00:30:13  Swayambhunath Temple: building started 460AD
00:00:42:21  Durbar Square
00:01:05:06  Driving to Trisuli River for Rafting
00:01:55:22  Day 1 Trekking: Pokhara to Tirkhedhunga (1540m)
00:02:20:20  Day 2 Trekking: Tirkhedhunga to Ghorephani (2750m)
00:02:33:19  Day 3 Trekking: Ghorephani to Ghandruk (1940m)
00:02:42:04  Day 4 Trekking: Ghandruk to Pothana (1900m)
00:03:10:13  Day 5 Trekking: Pothana to Phedi (1130m)

It'll take a while for your example to filter down into my brain - when 
it does I'll get back to you about it.

Awesome!

Thanykou so much!

Adam


Peter Szinek wrote:
> Adam Teale wrote:
>> hi Guys,
>> 
>> I have a tab-delimited text file that I would like to convert into an
>> xml file that can be read/imported into Apple's Final Cut Pro.
>> 
>> The text file is 2 columns.
>> The first column is the time (timecode)
>> The second column is text (for sub-titling)
> 
> Could you send us 2 example files? I guess the text file format is
> obvious (but better to work with a real-life example) but I am not so
> sure about the Final Cut Pro XML (or is it just a plain simple XML?)
> 
> Until then, check out this code:
> 
> ============================================================
> input = <<INPUT
> 0.12    Salut, Foo!
> 0.15    Hola Bar! Did you see Baz?
> 0.22    I guess he is hanging around with Fluff and Ork.
> INPUT
> 
> template = <<TEMPLATE
>   <timecode>TIMECODE</timecode>
>   <sub-titling>SUB-TITLING</sub-titling>
> TEMPLATE
> 
> result = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n"
> 
> input.split(/\n/).each do |line|
>   data = line.split(/\t/)
>   result += 
> template.sub('TIMECODE'){data[0]}.sub('SUB-TITLING'){data[1]}
> end
> 
> result += '</xml>'
> 
> puts result
> ============================================================
> 
> output:
> 
> <?xml version="1.0" encoding="ISO-8859-1"?>
>   <timecode>0.12</timecode>
>   <sub-titling>Salut, Foo!</sub-titling>
>   <timecode>0.15</timecode>
>   <sub-titling>Hola Bar! Did you see Baz?</sub-titling>
>   <timecode>0.22</timecode>
>   <sub-titling>I guess he is hanging around with Fluff and
> Ork.</sub-titling>
> </xml>
> 
> 
> Cheers,
> Peter
> 
> __
> http://www.rubyrailways.com


-- 
Posted via http://www.ruby-forum.com/.