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 .

[sunny_talwar]

You want this in multiple columns and not a single row?

[pipuindia99]

I think Ahmad Kastero is expecting like that...

[pipuindia99]

I think Ahmad Kastero is expecting like that...

[sunny_talwar]

Oh okay, for a moment I thought you were the one who asked the question. My apologies

[pipuindia99]

[jood_ahmad]

thank you but in this way i will have many records because the table that i will load from more than 3- million records

[sunny_talwar]

Then how exactly you want to do this?

[pipuindia99]

I think you can do it in scripting itself, so you will get the values split

[Anil_Babu_Samineni]

Jood_Ahmad

Is this you are expecting

[jood_ahmad]

yes like this how can i get it.