Re: Double Eval and Concat

wilkies0106aw — Mon, 09 May 2016 13:38:43 GMT

One Step closer.

I've now changed my formula as follows:

substring(eval(eval(Date[Hours > 0] | Hours[. > 0] | FullPartTime[Hours > 0], 'concat(";", .)'), ".."), 2)

Output is 2016-05-09T00:00:00;AM;7;2016-05-10T00:00:00;PM;7

This at least gives me all my columns and data. I'm sure it can be done cleaner.

AM/PM is not always going to be present

Next step is to take 2016-05-09T00:00:00;AM;7;2016-05-10T00:00:00;PM;7 and turn it into 2016-05-09 7 AM : 2016-05-09 7 PM

Double Eval and Concat

wilkies0106aw — Mon, 09 May 2016 11:48:59 GMT

All,

Currently attempting to output rows of data from a repeating table to one long line.

My repeating table has the columns date/hours/other

My current formula is substring(eval(eval(Date[Hours > 0], 'concat(";", .)'), ".."), 2)

This outputs the date of each row only.

No matter, how I concatenate I can't seem to get the date and the corresponding hours.

Any ideas?