Jon,
Use the {%row} special field: Set {DOB}=$e({%row},2,6)
// Use the following line if you want a field
// with just spaces to be considered NULL
Set:$tr({DOB}," ")="" {DOB}=""-dave
Jon Astle wrote:
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
