Wednesday, August 27, 2008

WORD Document Find and replace , with Enter key or new line

I got a doucument with all the 10,000 items separated with "," , now I need to upload this data in excel/sql table. If I will able to do all the Items in one row I can upload or do copy and paste.
original doc
1608129, 1613880, 1614159, 1614206, 1615976, 1616131, 1616132, 1616174, 1616299, 1616352, 1616623, 1616723, 1616744, 1616804, 1616859, 1616860, 1616947, 1616956, 1616968, 1616971, 1616976, 1616980, 1616981, 1616991, 1616994, 1616997, 1617017, 1617025, 1617036, 1617039, 1617040, 1617043, 1617049, 1617052, 1617053, 1617065, ........
I will have to do
1608129
1613880
1614159
1614206
1615976
1616131
1616132
1616174
1616299
....
....

What I did find and replace comma , with
,
1608129
1613880
1614159
1614206
1615976
1616131
1616132
1616174

after open an html editor (visual stdios / blogger)
and paste. after that I did browse/ Preview in IE , got data in
1608129
1613880
1614159
1614206
1615976
1616131
above form copy and paste this data in text file after that you can upload this data.

1 comment:

Reena the Romantic said...

Sir could you please give a full description ?