Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| Web Programming, Web 2.0 and Mashups Discuss Web Programming and Web Server Administration, including LAMP, Apache, MySQL, Flash, HTML, SEO, Mashups and other Web APIs and topics. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Joining two files based on columns/fields | rudoraj | Shell Programming and Scripting | 11 | 09-06-2008 04:47 PM |
| How to check Null values in a file column by column if columns are Not NULLs | Mandab | Shell Programming and Scripting | 7 | 03-15-2008 09:57 AM |
| How to split a field into two fields? | vbrown | Shell Programming and Scripting | 4 | 02-21-2008 06:50 AM |
| how to get the columns name and fields from this file. | rnallamothu | Shell Programming and Scripting | 15 | 06-13-2007 08:14 AM |
| returning split fields | mervin2006 | Shell Programming and Scripting | 3 | 05-11-2007 01:21 PM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
02-23-2009
|
||||
|
||||
|
split the fields in a column into 3 columns
Have a column "address" which is combination of city, region and postal code like.
Format is : city<comma><space>region<space>postal code abc, xyz 123456 All these three city, region and postal code are not mandatory. There can be any one of the above. In that case a nell needs to be inserted. Need to split these fields into 3 columns city, region and postal code and insert into another table. script can be in mysql or sqlserver Thanks |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
