It's not clear from the picture above if the acctcode and acctname are join together.
However, best bet will be to use Subfield()
subfield(S, ';' ,2)
returns 'cde' if S is 'abc;cde;efg'
subfield(S, ';' ,1)
returns NULL if S is an empty string
Try Subfield and let us know if it workd.
acctcode is seperate...numbers(integer)
acctname is character...
are you able to see the levels(1-5)?
level1 is integer...
but i need level1name by using the acctname...
AcctName as L1Name
where Level 1 = AcctCode;
whehther this script will be correct or not?
but i cant get exact names by using this scripting
everybody who refer this discussion....
i have solved it by myself using applymap...
Mapping Load Acctcode,
ApplyMap('SegMap',[Level 1],'N/A') as L1Name,
ApplyMap('SegMap',[Level 2],'N/A') as L2Name,
ApplyMap('SegMap',[Level 3],'N/A') as L3Name,
ApplyMap('SegMap',[Level 4],'N/A') as L4Name,
ApplyMap('SegMap',[Level 5],'N/A') as L5Name
I have extracted names from the AcctName to the respective Levels successfully..