RSS Feed Help

[tumbleweed1993sf]

I'm writing an RSS feed which will tell me the start time of MLB games. The problem is that all of times are written to reflect the Eastern Time Zone, so each time is 3 hours ahead. I'm curious to know if there's some sort of mathematical function I can use to substitute these times to reflect the Pacific Time Zone, or if I have to manually substitute each start time with the respective Pacific start time.

The feed isn't parsed so the start time string isn't separate from the rest of the text, so I cannot simply change the time string. Is this the only way to do it? To parse the time string separately?

[Kaelri]

Yes, you need to isolate the time (specifically the hour) as a separate string index. On the bright side, if you can do that, performing mathematical functions on it will be very easy.

[Seahorse]

TimeZone
The timezone value (e.g. TimeZone=+2.0). You can use also fractional values. If this is not given the local time is used.

Looks like someone has though of this for you...

[Kaelri]

Looks like someone has though of this for you...

That won't help with WebParser strings, unfortunately.

[Seahorse]

Then either use substitution (I don't think their is a limit) or a calc that adds 3...

Code: Select all

Substitute="0000":"0300","0100":"0400","0200":"0500"...etc

Code: Select all

[HoursCalc]
Measure=Calc
Formula=(YourHoursMeter+3)

Mind you possibly some danger of 27 o'clock!

[tumbleweed1993sf]

Alrighty thanks for the input guys. I went ahead and manually inputted each possible start time after all. It took up a lot of space and took quite a while, but it's worth it!

[smurfier]

If you give me a sample output of the regex that shows exactly what the time looks like, I can probably give you a formula to use.