how to split a row item n insert it in another table

vikvikash

hi
i have split the data using the split command now i want to insert the split data to be inserted into another table. there r many records in the previous table i want each record to be split and inserted into the other table one by one.....



25 123454756741 $GPRMC,093729.000,A,1301.7595,N,08015.2751,E,1.13, 69.84,080210,,*3E,BAUTO 0 3/9/2010 3:07:29 PM

i want to split the underlined data using "," and insert it into another table...
there r many such records i want to split each and every records and insert it to another table

Mar 22 '10 #1

Soniad

Hi,

In SQL u can use CHARINDEX to split string.

check the following link :
http://www.databasejournal.com/featu...d-PATINDEX.htm

Regards,

"D"

Mar 22 '10 #2

vikvikash

Hi there,
i have split the underlined text using c# code now what i want is to insert it to another table but there would be several such records.
i want to split each record n insert it to another table.

Mar 22 '10 #3

ck9663

Is the text from a table? Or a form?

~~ CK

Mar 22 '10 #4

vikvikash

Hi CK

The text is from a table n not a form.

Mar 23 '10 #5

ck9663

Here's a pseudo-code...

1.. Parse your string on your SELECT statement using the comma as delimiter/identifier and the dollar sign as the marker to start the parsing.
2.Insert it using the INSERT INTO TABLE .... SELECT col1, ParsedColumnAlias FROM YourTable.

Happy Coding!!!

~~ CK

Mar 23 '10 #6

nbiswas

Try this:

Solution 1(Using XQuery Approach)
OUTPUT

Hope this helps

Mar 24 '10 #7