Code Forums - View Single Post

heinz1218 · 07-13-2006, 10:05 AM

hey all

i've got some data that i'm getting from SBA's website in comma-delimited form, and i'm trying to import into Excel.

http://dsbs.sba.gov/dsbs/dsp_dsbs.cfm

however some of the data includes hitting the "enter" key, and screws up import in to excel. I have thousands of lines to go through, and it happens ever 10 lines or so, so i need to write something to take care of it. I've done a little bit of coding, though mostly web-based (php, javascript, asp, etc). Anyway it's been awhile, but I know there should be a pretty quick way for me to do this....Any suggestions? maybe java would be easier?

also, would this be using reg exps, or are there such things in C?

I don't have any compiliers on this computer so any help is much appreciated...thanks guys.

07-13-2006, 10:05 AM	#1 (permalink)
heinz1218 Registered User Join Date: Jul 2006 Posts: 9	can i clean up my data with C hey all i've got some data that i'm getting from SBA's website in comma-delimited form, and i'm trying to import into Excel. http://dsbs.sba.gov/dsbs/dsp_dsbs.cfm however some of the data includes hitting the "enter" key, and screws up import in to excel. I have thousands of lines to go through, and it happens ever 10 lines or so, so i need to write something to take care of it. I've done a little bit of coding, though mostly web-based (php, javascript, asp, etc). Anyway it's been awhile, but I know there should be a pretty quick way for me to do this....Any suggestions? maybe java would be easier? also, would this be using reg exps, or are there such things in C? I don't have any compiliers on this computer so any help is much appreciated...thanks guys.