Hello,

I'm working on a little project to extract weather data from website.
At this point, I've stored each weather information on one line in a UNIX standard file.
Each line has the structure:

Code:

dd-mm-yy:City:dd-mm-yy:kind Of Data:value Of Data

the first dd-mm-yy (it's the french format because I'm french) is the date of the download of the forecasts weather, the second dd-mm-yy is the day for the forecasts (it could be the day of the download, the day after the download, the day after the day of the download etc...).

I'll now give an example of forecast, I use 5 lines:

Code:

08-12-10:Paris:10-12-10:Windspeed:20 km/h
08-12-10:Paris:10-12-10:Windcourse:Wind north north-east
08-12-10:Paris:10-12-10:Sky:Some breaks
08-12-10:Paris:10-12-10:Max:5°C
08-12-10:Paris:10-12-10:Min:-3°C

Well, now my problem, I need to catch the different values on some variables:
for example, I'd like to have in 5 variables ($downloadDay, $City, $forDate etc...) the 5 arguments of a line (only for 1 line!) and I need a little tips.

Actually, I get the line using the sed command and I store the line in a variable.
Then I get the values with the expr command, my commands are:

Code:

downloadDay=`expr "$myline" : '\(........\)'`
city=`expr "$myline" : '.*\([A-Z][a-z]*\):[0-9]'`
forecastday= # I cut it to display the command, in the script it's linked
`expr "$myline" : '.*[a-z]:\([0-9][0-9]-[0-9][0-9]-[0-9][0-9]-[0-9][0-9]\):[A-Z]'`
kindOfData=`expr "$myline" : '.*[0-9]:\([A-Z][a-z]*\)'` 
valueOfData=`expr "$myline" : '.*[a-z]:\(.*\)'`

the two elements which fail are: the forecastday and the valueOfData

for the forecastday, I've more than 100 lines in my weather base, sometimes it's run, but sometimes it fails:

Run:

Code:

03-12-10:Mulhouse:04-12-10:Ciel:Soleil voilé

Fail:

Code:

03-12-10:Versaille:03-12-10:Ciel:Quelques éclaircies

for the valueOfData:

Actually, the data is cut when I've a space: 50 km/h -> 50
some breaks-> some etc...

I think that my problem comes from the 5 regex with expr, I'm new in this domain, so if somebody could have a look and explain me what's wrong and how to fix it (if possible with a regex explanation to understand why that not run) It'd be very very very nice!

Big thanks in advance!

Moderator's Comments:

Please use code tags when posting data and code samples!