I have a REXX script that inserts 'tide events' from tide tool into MySQL table, essentially it parses tide's output into event/date/time/height, and, inserts into MySQL table. I'm guessing it could be just a shell script to do it, rather than my current script. (and, suspect the writing the shell script might be simpler than adapting the REXX script...) the entire output is less than 40 lines in the format:
# tide -l sydney Sydney, Australia 33.8500░ S, 151.2333░ E 2004-09-06 12:50 AM EST 1.15 meters High Tide 2004-09-06 6:06 AM EST Sunrise 2004-09-06 6:39 AM EST 0.65 meters Low Tide 2004-09-06 10:00 AM EST Moonset 2004-09-06 1:23 PM EST 1.43 meters High Tide 2004-09-06 5:40 PM EST Sunset 2004-09-06 8:16 PM EST 0.67 meters Low Tide .... I'd like to drop the first 3 lines, parse the data, add DOW to date, and, insert into MySQL similar to: Low Tide Friday 2004-09-10 10:26 AM 0.56 all help, as always, greatly appreciated -- Voytek -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
