separate code.

[#1]

Hello,

In my field called item I found thesecodes:

--------------------------------------------------------
Item
--------------------------------------------------------
codeXX-125

cd-A25
mycodenew-1lp01
--------------------------------------------------------

The structure is build like below:

s-b

part "a", dash and part "b"

So, I would to separate the part a to part b in this way:

code1:
codeXX
cd
mycodenew

code 2:

125
A25
1lp01

Please could to help me?
Thanks
Best Regards

--

Slash [:)]

[Anonymous · Accepted solution]

Slash,
Looks like you are looking for subfield:
subfield(code,'-',1) as code1
subfield(code,'-',2) as code2

[#3]

Many Thanks,

regards.

--

Slasj