|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
August 27th, 2003, 11:58 AM
|
|||
|
|||
Converting rows to colums
I am having trouble converting form messages which come to me in this format:
Name: joe schmo Address: 123 main st City: beverly hills State: ca Zip: 90210 Phone: 555-555-5555 Email: URL to a usable database (in either Access or Excel, I don't care which) like this: Name Address City joe schmo 123 main st beverly hills You get the idea. Any help would be greatly appreciated!
|
|
#2
August 27th, 2003, 05:25 PM
|
|||
|
|||
|
and you want to change a dynamic message into a schema entirely though SQL?
|
|
#3
August 27th, 2003, 05:25 PM
|
||||
|
||||
|
You will have to write a parser in some language. I am sure it could be done in SQL, though I expect it would be quite painful. Try Perl.
__________________
Left DevShed May 28, 2005. Reason: Unresponsive administrators. Free code: http://sol-biotech.com/code/. Secure Programming: http://sol-biotech.com/code/SecProgFAQ.html. Performance Programming: http://sol-biotech.com/code/PerformanceProgramming.html. It is not that old programmers are any smarter or code better, it is just that they have made the same stupid mistake so many times that it is second nature to fix it. --Me, I just made it up The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man. --George Bernard Shaw
|
|
#4
August 27th, 2003, 05:27 PM
|
|||
|
|||
|
almost to the point of suicide.... I'm not even going to start thinking about it unless you have another language possibliity. Whatever language, it'd be easiest to do splits on : and then do a left and right trim, and then start working with DDL language within sql creating left of : and inserting right of colon, shouldn't be hard...
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Converting rows to colums |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
