Need Help

[pinky1234]

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?

[sunny_talwar · Accepted solution]

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,