Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i build a "key" like ABC34_2324_234234234.
Now I want to devide it like:
ABC34
2324
234234234
I did this with left(key, 5) as Key 1
etc.
I wanted to ask if it is possible to devide by using "_" so that the lenght of each key doesn't matter.
Thank you fpr helping!
subfield(Key,'_',1) as Key1,
subfield(Key,'_',2) as Key2,
subfield(Key,'_',3) as Key2,
subfield(Key,'_',1) as Key1,
subfield(Key,'_',2) as Key2,
subfield(Key,'_',3) as Key2,
Try to use Subfield...
You can use the function SubField() e.g.
SubField(Key,'_',1)
SubField(Key,'_',2)
SubField(Key,'_',3)
Take a look to Subfield function:
try below
a:
LOAD * INLINE [
Data
ABC34_2324_234234234
];
Result:
LOAD *,
SubField(Data,'_') as key
Resident a;
Hi,
Try using the SubField function. Something like this:
Key1 = SubField( key,'_')
Something I just learned recently.
With this function you can even pull out the next field as in:
Key2 = SubField( key,'_',2)
Hope this is what you need!
- Stan