what is the below code line means? power builder

gvilbis used Ask the Experts™
dw_sheet.SetItem(iRow,"date", date( mid(sShip_Sunday,5,2) + '/' + mid(sShip_Sunday,7,2)+'/'+left(sShip_Sunday,4) ) )
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

Looks like it is trying to take a date literal in the form yyyymmdd, convert it to a date literal in the form mm/dd/yyyy, convert that into a date, and stick it into a worksheet or grid.

It has nothing to do with Regular Expressions :)

SetItem is described here:
Date function - text to date conversion.
sShip_Sunday  seems to be date without delimiters (like 20110516) and it is converted to 2011/05/16 and is whitten to "date" column, row iRow

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial