Jon, What I have usually done in these situations is retrieve the whole string as the mapped data element, then create calculated columns/properties to do the data extraction. It seems to work reliably, with no real performance issues I have identifed. Mark
"Jon Astle" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi All > > I know this topic had been discussed on many occasions but I can seem to get > this to work. > I am mapping sqlcustomstorage to an existing global. > The data comes back in a long string and is not delimetered and I want to > split it up into variables. > I need to write some retrieval code in the mapper to split this data up. > > Global > > ^GLOBAL(Sub1,Sub2,Sub3)=JONASTLE > > Property Sub1 > Property Sub2 > Property Sub3 > Property Data > Property Forename > Property Surname > > How can I do this ? > > I have tried > > s (*)=$e(Data,1,3) > ...... > s (*)=$e(*,1,3) > > etc etc > > Thanks in advance. > > Jon > >
