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
