Hi 0521, sorry I’m not in front of my v7 machine now but will try and look at your project later. In the meantime I quickly mocked up a couple of alternative steps that might be useful in the attached v6.4 project.
First step gets rid of leading undescore and trailing h.
second uses the replace option to insert the decimal point.
mid(timetext,2,(length(timetext)-2))
replace(time1,2,1,“.”)
sometimes the DW gets a little unhappy if the lenght of the text string is differing and some steps ask for locations longer than the shortest text string.
you get a message like;
'There was an error while executing Workflow.Data Wizard 1
Index was outside the bounds of the array.’
For this reason I try to break things down into a couple of steps so I can minimise these problems.