split a column

[jood_ahmad]

Dears,

if i have in one var-char column these value

( -059;+308;+SFCRF0012;601;+671;671;024;023;043;061;033;059 )

( -664;-664;-664;101;+636;671;664;047;@101 )

( +204;601;671 )

and i need to split it to columns as per the number value after each ( ; ) as a new column  is this possible in QV .

[pipuindia99]

Yes, you can use subfield function

[jood_ahmad]

but Subfield wil not work on this case. i need all the values but in separate columns. subfield will take one value as per the position.

[pipuindia99]

use the subfield function by adding a expression and give this fieldname. it should work

[sunny_talwar]

I think this is what pipuindia99‌ is trying to say

Table:

LOAD *,

  SubField(FieldName, ';') as NewFieldName;

LOAD * Inline [

FieldName

-059;+308;+SFCRF0012;601;+671;671;024;023;043;061;033;059

-664;-664;-664;101;+636;671;664;047;@101

+204;601;671

];

[pipuindia99]

Yes, but to get all we can give frequency for each

[sunny_talwar]

Like this?

Table:

LOAD *,

  SubStringCount(FieldName, NewFieldName) as Frequency;

LOAD *,

  SubField(FieldName, ';') as NewFieldName;

LOAD * Inline [

FieldName

-059;+308;+SFCRF0012;601;+671;671;024;023;043;061;033;059

-664;-664;-664;101;+636;671;664;047;@101

+204;601;671

];

[pipuindia99 · Accepted solution]

SubField(fieldname,'.','1') and in next expression SubField(fieldname,'.','2') .....

[pipuindia99]

SubField(fieldname,';','1') and in next expression SubField(fieldname,';','2') .....

[pipuindia99]

so each values would be in different columns...