Sponsored Content
Top Forums Web Development split the fields in a column into 3 columns Post 302290469 by Neo on Monday 23rd of February 2009 11:38:42 AM
Old 02-23-2009
mysql is not a script, it is a database.

Normally you use a language like PHP or PERL as the scripting language and that script calls a mysql function.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

split one column into multiple columns

hey guys... Im looking to do the following: 1 2 3 4 5 6 7 8 9 Change to: 1 4 7 2 5 8 3 6 9 Did use | perl -lpe'$\=$.%3?$":"\n"' , but it doesnt give me the matrix i want. (3 Replies)
Discussion started by: zaneded
3 Replies

2. Shell Programming and Scripting

split one column into multiple columns

hey, i have the following data: 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 (7 Replies)
Discussion started by: zaneded
7 Replies

3. Shell Programming and Scripting

awk to split one field and print the last two fields within the split part.

Hello; I have a file consists of 4 columns separated by tab. The problem is the third fields. Some of the them are very long but can be split by the vertical bar "|". Also some of them do not contain the string "UniProt", but I could ignore it at this moment, and sort the file afterwards. Here is... (5 Replies)
Discussion started by: yifangt
5 Replies

4. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

5. UNIX for Dummies Questions & Answers

Split a column into multiple columns at certain character count

Hey everyone, I have an issue with a client that is passing me a list of values in one column, and occasionally the combination of all the values results in more than an 255 character string. My DB has a 255 character limit, so I am looking to take the column (comma delimited file), and if it... (1 Reply)
Discussion started by: perekl
1 Replies

6. Shell Programming and Scripting

Split text separated by ; in a column into multiple columns

Hi, I need help to split a long text in a column which is separated by ; and i need to print them out in multiple columns. My input file is tab-delimited and has 11 columns as below:- aRg02004 21452 asdfwf 21452 21452 4.6e-29 5e-29 -1 3 50 ffg|GGD|9009 14101.10 High class -node. ; ffg|GGD|969... (3 Replies)
Discussion started by: redse171
3 Replies

7. Shell Programming and Scripting

awk split columns after matching on rows and summing the last column

input: chr1 1 2 3 chr1 1 2 4 chr1 2 4 5 chr2 3 6 9 chr2 3 6 10 Code: awk '{a+=$4}END{for (i in a) print i,a}' input Output: chr112 7 chr236 19 chr124 5 Desired output: chr1 1 2 7 chr2 3 6 19 chr1 2 4 5 (1 Reply)
Discussion started by: jacobs.smith
1 Replies

8. UNIX for Dummies Questions & Answers

Split 1 column into numerous columns based on patterns

Hi, I have a text file 'Item_List.txt' containing only 1 column. This column lists different products, each separated by the same generic string header "NEW PRODUCT, VERSION 1.1". After this the name of the product is given, then a delimiter string "PRODUCT FIELD", and then the name of the... (11 Replies)
Discussion started by: mmab
11 Replies

9. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ... (4 Replies)
Discussion started by: ranjancom2000
4 Replies

10. UNIX for Beginners Questions & Answers

Using awk to split a column into two columns

Hi, I am trying to split the following output into two columns, where each column has Source: Destination: OUTPUT TO FILTER $ tshark -r Capture_without_mtr.pcap -V | awk '/ (Source|Destination): /' | more Source: x.x.x.x Destination: x.x.x.x Source:... (2 Replies)
Discussion started by: sand1234
2 Replies
Regexp::Common::zip(3pm)				User Contributed Perl Documentation				  Regexp::Common::zip(3pm)

NAME
Regexp::Common::zip -- provide regexes for postal codes. SYNOPSIS
use Regexp::Common qw /zip/; while (<>) { /^$RE{zip}{Netherlands}$/ and print "Dutch postal code "; } DESCRIPTION
Please consult the manual of Regexp::Common for a general description of the works of this interface. Do not use this module directly, but load it via Regexp::Common. This module offers patterns for zip or postal codes of many different countries. They all have the form "$RE{zip}{Country}[{options}]". The following common options are used: "{-prefix=[yes|no|allow]}" and "{-country=PAT}". Postal codes can be prefixed with a country abbreviation. That is, a dutch postal code of 1234 AB can also be written as NL-1234 AB. By default, all the patterns will allow the prefixes. But this can be changed with the "-prefix" option. With "-prefix=yes", the returned pattern requires a country prefix, while "-prefix=no" disallows a prefix. Any argument that doesn't start with a "y" or a "n" allows a country prefix, but doesn't require them. The prefixes used are, unfortunally, not always the same. Officially, ISO country codes need to be used, but the usage of CEPT codes (the same ones as used on cars) is common too. By default, each postal code will recognize a country prefix that's either the ISO standard or the CEPT code. That is, German postal codes may prefixed with either "DE" or "D". The recognized prefix can be changed with the "-country" option, which takes a (sub)pattern as argument. The arguments "iso" and "cept" are special, and indicate the language prefix should be the ISO country code, or the CEPT code. Examples: /$RE{zip}{Netherlands}/; # Matches '1234 AB' and 'NL-1234 AB'. /$RE{zip}{Netherlands}{-prefix => 'no'}/; # Matches '1234 AB' but not 'NL-1234 AB'. /$RE{zip}{Netherlands}{-prefix => 'yes'}/; # Matches 'NL-1234 AB' but not '1234 AB'. /$RE{zip}{Germany}/; # Matches 'DE-12345' and 'D-12345'. /$RE{zip}{Germany}{-country => 'iso'}/; # Matches 'DE-12345' but not 'D-12345'. /$RE{zip}{Germany}{-country => 'cept'}/; # Matches 'D-12345' but not 'DE-12345'. /$RE{zip}{Germany}{-country => 'GER'}/; # Matches 'GER-12345'. "{-sep=PAT}" Some countries have postal codes that consist of two parts. Typically there is an official way of separating those parts; but in practise people tend to use different separators. For instance, if the official way to separate parts is to use a space, it happens that the space is left off. The "-sep" option can be given a pattern as argument which indicates what to use as a separator between the parts. Examples: /$RE{zip}{Netherlands}/; # Matches '1234 AB' but not '1234AB'. /$RE{zip}{Netherlands}{-sep => 's*'}/; # Matches '1234 AB' and '1234AB'. $RE{zip}{Australia} Returns a pattern that recognizes Australian postal codes. Australian postal codes consist of four digits; the first two digits, which range from '10' to '97', indicate the state. Territories use '02' or '08' as starting digits; the leading zero is optional. '0909' is the only postal code starting with '09' (the leading zero is optional here as well) - this is the postal code for the Nothern Territory University). The (optional) country prefixes are AU (ISO country code) and AUS (CEPT code). Regexp::Common 2.107 and before used $RE{zip}{Australia}. This is still supported. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The state or territory. $5 The last two digits. $RE{zip}{Belgium} Returns a pattern than recognizes Belgian postal codes. Belgian postal codes consist of 4 digits, of which the first indicates the province. The (optional) country prefixes are BE (ISO country code) and B (CEPT code). If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The digit indicating the province. $5 The last three digits of the postal code. $RE{zip}{Denmark} Returns a pattern that recognizes Danish postal codes. Danish postal codes consist of four numbers; the first digit (which cannot be 0), indicates the distribution region, the second the distribution district. The (optional) country prefix is DK, which is both the ISO country code and the CEPT code. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The digit indicating the distribution region. $5 The digit indicating the distribution district. $6 The last two digits of the postal code. $RE{zip}{France} Returns a pattern that recognizes French postal codes. French postal codes consist of five numbers; the first two numbers, which range from '01' to '98', indicate the department. The (optional) country prefixes are FR (ISO country code) and F (CEPT code). Regexp::Common 2.107 and before used $RE{zip}{French}. This is still supported. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The department. $5 The last three digits. $RE{zip}{Germany} Returns a pattern that recognizes German postal codes. German postal codes consist of five numbers; the first number indicating the distribution zone, the second the distribution region, while the latter three indicate the distribution district and the postal town. The (optional) country prefixes are DE (ISO country code) and D (CEPT code). Regexp::Common 2.107 and before used $RE{zip}{German}. This is still supported. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The distribution zone. $5 The distribution region. $6 The distribution district and postal town. $RE{zip}{Greenland} Returns a pattern that recognizes postal codes from Greenland. Greenland, being part of Denmark, uses Danish postal codes. All postal codes of Greenland start with 39. The (optional) country prefix is DK, which is both the ISO country code and the CEPT code. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 39, being the distribution region and distribution district for Greenland. $5 The last two digits of the postal code. $RE{zip}{Italy} Returns a pattern recognizing Italian postal codes. Italian postal codes consist of 5 digits. The first digit indicates the region, the second the province. The third digit is odd for province capitals, and even for the province itself. The fourth digit indicates the route, and the fifth a place on the route (0 for small places, alphabetically for the rest). The country prefix is either IT (the ISO country code), or I (the CEPT code). If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The region. $5 The province. $6 Capital or province. $7 The route. $8 The place on the route. $RE{zip}{Netherlands} Returns a pattern that recognizes Dutch postal codes. Dutch postal codes consist of 4 digits and 2 letters, separated by a space. The separator can be changed using the "{-sep}" option, as discussed above. The (optional) country prefix is NL, which is both the ISO country code and the CEPT code. Regexp::Common 2.107 and earlier used $RE{zip}{Dutch}. This is still supported. If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The digits part of the postal code. $5 The separator between the digits and the letters. $6 The letters part of the postal code. $RE{zip}{Norway} Returns a pattern that recognizes Norwegian postal codes. Norwegian postal codes consist of four digits. The country prefix is either NO (the ISO country code), or N (the CEPT code). If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $RE{zip}{Spain} Returns a pattern that recognizes Spanish postal codes. Spanish postal codes consist of 5 digits. The first 2 indicate one of Spains fifties provinces (in alphabetical order), starting with 00. The third digit indicates a main city or the main delivery rounds. The last two digits are the delivery area, secondary delivery route or a link to rural areas. The country prefix is either ES (the ISO country code), or E (the CEPT code). If "{-keep}" is used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The two digits indicating the province. $5 The digit indicating the main city or main delivery route. $6 The digits indicating the delivery area, secondary delivery route or a link to rural areas. $RE{zip}{Switzerland} Returns a pattern that recognizes Swiss postal codes. Swiss postal codes consist of 4 digits. The first indicates the district, starting with 1. The second indicates the area, the third, the route, and the fourth the post office number. $RE{zip}{US}{-extended => [yes|no|allow]} Returns a pattern that recognizes US zip codes. US zip codes consist of 5 digits, with an optional 4 digit extension. By default, extensions are allowed, but not required. This can be influenced by the "-extended" option. If its argument starts with a "y", extensions are required; if the argument starts with a "n", extensions will not be recognized. If an extension is used, a dash is used to separate the main part from the extension, but this can be changed with the "-sep" option. The country prefix is either US (the ISO country code), or USA (the CEPT code). If "{-keep}" is being used, the following variables will be set: $1 The entire postal code. $2 The country code prefix. $3 The postal code without the country prefix. $4 The first 5 digits of the postal code. $5 The first three digits of the postal code, indicating a sectional center or a large city. New in Regexp::Common 2.119. $6 The last 2 digits of the 5 digit part of the postal code, indicating a post office facility or delivery area. New in Regexp::Common 2.119. $7 The separator between the 5 digit part and the 4 digit part. Up to Regexp::Common 2.118, this used to be $5. $8 The 4 digit part of the postal code (if any). Up to Regexp::Common 2.118, this used to be $6. $9 The first two digits of the 4 digit part of the postal code, indicating a sector, or several blocks. New in Regexp::Common 2.119. $10 The last two digits of the 4 digit part of the postal code, indicating a segment or one side of a street. New in Regexp::Common 2.119. You need at least version 5.005_03 to be able to use US postal codes. Older versions contain a bug that let the pattern match invalid US postal codes. Questions o Can the 5 digit part of the zip code (in theory) start with 000? o Can the 5 digit part of the zip code (in theory) end with 00? o Can the 4 digit part of the zip code (in theory) start with 00? o Can the 4 digit part of the zip code (in theory) end with 00? SEE ALSO
Regexp::Common for a general description of how to use this interface. <http://www.columbia.edu/kermit/postal.html> Frank's compulsive guide to postal addresses. <http://www.upu.int/post_code/en/addressing_formats_guide.shtml> Postal addressing systems. http://www.uni-koeln.de/~arcd2/33e.htm <http://www.uni-koeln.de/~arcd2/33e.htm> Postal code information. <http://www.grcdi.nl/linkspc.htm> Links to Postcode Pages. <http://www1.auspost.com.au/postcodes/> Information about Australian postal codes. http://hdusps.esecurecare.net/cgi-bin/hdusps.cfg/php/enduser/std_adp.php?p_faqid=1014 <http://hdusps.esecurecare.net/cgi- bin/hdusps.cfg/php/enduser/std_adp.php?p_faqid=1014> Information about US postal codes. <http://en.wikipedia.org/wiki/Postal_code> AUTHORS
Damian Conway (damian@conway.org) and Abigail (regexp-common@abigail.be). MAINTAINANCE
This package is maintained by Abigail (regexp-common@abigail.be). BUGS AND IRRITATIONS
Zip codes for most countries are missing. Send them in to regexp-common@abigail.be. LICENSE and COPYRIGHT This software is Copyright (c) 2001 - 2009, Damian Conway and Abigail. This module is free software, and maybe used under any of the following licenses: 1) The Perl Artistic License. See the file COPYRIGHT.AL. 2) The Perl Artistic License 2.0. See the file COPYRIGHT.AL2. 3) The BSD Licence. See the file COPYRIGHT.BSD. 4) The MIT Licence. See the file COPYRIGHT.MIT. perl v5.14.2 2010-02-23 Regexp::Common::zip(3pm)
All times are GMT -4. The time now is 10:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy