Hi Jon,
probably your problem is that in retrieval code you have only the
index data available (Sub1, Sub2, Sub3) and not Data. So either you
have to read the Global node in your retrieval Code and then work with
the value you get :
Set xData=^GLOBAL({Sub1},{Sub2},{Sub3})
Set {Forename}=$E(xData(1,3))
or use calculated fields, even if you have to define the code twice
(for SQL and for objects), as Mark suggests.
Regards
Seppo
"Jon Astle" <[EMAIL PROTECTED]> schrieb:
>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
>
