I use Text::xSV to read (and write) text delimited (in this case '_' ?) files a line at a time </plug>

You need to edit your post to break up your data. It appears as one long line, which makes it difficult to understand your question. If your actual data really is a single long line of characters with no whitespace or newlines, then truncate it -- I doubt we need to see that much data.

For a clean maintainable solution you have to use a multi-dimensional array, something like this:

#Store an entry:
$speed[1][1]['weekday']= 32.61712;
#or when you load values from a CSV file (I assume all values on one l
+ine:
my $line=<csvfile>;
my @speeds= split $line;
my $link_no=1;
my $i=1;
my $day='weekday';
foreach (@speeds) {
  $speed[$link_no][$i++][$day]= $_;
}
[download]

sorry....... i have changed the format of my post.

Jethro: the common is at every 192 of speed value, i trucated the dataset and only put one link speed record here, there are 66 links in the dataset. sorry for the confusion. thanks for your suggestion, i will give it a try now.

It seems you do not understand the problem with your post format. Perhaps you may have noticed that to see the far right of your post, people need to scroll many, many screenfuls? This is considered very impolite and the solution is to surround that one very, very long line with <code> tags, like this:

<code>
32.61712_29.23591_24.84628_22.84434_30.59529_28.76819_35.03523_30.9736
+7_30.5064_38.87624_49.87962_51.24486_47.32718_48.00002_51.71957_44.31
+798_39.75034_48.64877_30.88166_36.76909_54.46225_38.02563_30.29589_37
+.91334_21.44945_28.95672_22.03353_21.29655_23.84956_19.28472
</code>
[download]

Using code tags causes the text to wrap around. We still know that this is one long line because each wrapped line begins with a red + sign. The red plus doesn't show up in your input window though because it is still one long line there. Please, please, do what I did above to your original post so you won't annoy people further.

Best, beth