subfield and convert an hour

Sat, 18 Feb 2012 09:41:15 GMT

I have a file and I want to extract the column "Données" on the day the hour minute and seconds to do this calculation

((day*24)+hour+(minute/60)+(seconde/3600)).

Best Rgds

swuehl — Sat, 18 Feb 2012 12:49:43 GMT

Try maybe something like this:

TEST:

LOAD *,

interval(Extract) as Interval,

floor(Extract) as Day,

hour(Extract) as Hour,

minute(Extract) as Minute,

Second(Extract) as Second;

LOAD *,

interval#('0'&TextBetween(Données,'',' jour')&' '&right(KeepChar(Données,'0123456789'),6),'d hhmmss') as Extract INLINE [

Données

03H15m25s

11H14m15s

1 jour(s) 23H58m48s

22 jour(s) 09H22m25s

];

topic subfield and convert an hour in QlikView