Hi,
> 22;"5501289";"Győr";1;"07:39:00";"07:39:00";"910_22"
> 23;"5501289";"Győr";1;"07:41:00";"07:41:00";"910_23"
I'd like this:
<next count>; "5501289";"Győr"; "07:39:00"; "07:41:00"; "910_unknown"
> 28;"5544800";"Csorna";1;"08:00:00";"08:00:00";"910_28"
> 29;"5544800";"Csorna";1;"08:12:00";"08:12:00";"910_29"
For Csorna:
<next count>;"5544800";"Csorna";1;"08:00:00";"08:12:00";"910_unknown2"
_unknown means: it is a programmed selector, so not valid.
As you can see I want to merge the two time date in one record.
The problem comes from some specification misunderstood.
This timetable comes from three (almos) independent XML files.
> Indeed, I am not sure if I am understanding what you need.
Ihope you understand now.
> By duplicated record you mean records that have the first three columns the
> same ? E.G. ;"5544800";"Csorna";1; ?
Csorna and Győr is the problematic.
> And in these cases what do you need the train selector to be exactly?
I don't know exactly. I'm sure I have to change it because in the merged
record the sector is not valid.
> The left part of it (910) means what exactly?
vonatszam. In English: train number.
TIA,
Ruzsi