Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data like this shown in below in excelsheet. Below is the field has the chain data.I need to split the one field in to multiple fields like AAA as 1, BBB as 2, CCC as 3,EEE as 4,FFF as 5..etc
Field
AAA_BBB_CCC_DDD_EEE_FFF_GGG
Can anyone help on this?
May be using SubField
LOAD SubField(Field, '_', 1) as 1,
SubField(Field, '_', 2) as 2,
SubField(Field, '_', 3) as 3,
SubField(Field, '_', 4) as 4,
SubField(Field, '_', 5) as 5,
May be using SubField
LOAD SubField(Field, '_', 1) as 1,
SubField(Field, '_', 2) as 2,
SubField(Field, '_', 3) as 3,
SubField(Field, '_', 4) as 4,
SubField(Field, '_', 5) as 5,