I have a string like b-bghy-gnhytr-df-fgt.Need to split into 5 coloumns.
As well its size is not fixed..
Can any one help on this..
As Ernesto mentioned use subfield function, below is script which will help you split into 5 columns
load * inline [
SubField(word,'-',1) as one,
SubField(word,'-',2) as two,
SubField(word,'-',3) as three,
SubField(word,'-',4) as four,
SubField(word,'-',-1) as five
one solution could be:
LOAD RecNo() as %ID,
'Sub'&Autonumber(RowNo(),RecNo()) as ColNo,
SubField(string,'-') as substring
hope this helps