Hi,
I have created a tab separated file from the following input file.
Code:
ADDRESS1 CITY STATE POSTAL COUNTRY LON LAT
32 PRINZREGENTENSTRASSE ROSENHEIM BAYERN 83022 DEU 1212182 4785699
263 VIA DANTE ALIGHIERI BARI PUGLIA 70122 ITA 1686233 4112154
30 VIA MILANO TREVIGLIO LOMBARDIA 24047 ITA 956961 4552289
2 KREUZWEG ERSIGEN BERN 3423 CHE 759377 4709277
28 VICOLO DELLA FONTANA ROMA LAZIO 00198 ITA 1250887 4191608
3 MUNCHPLATZ 10. BEZIRK-FAVORITEN WIEN 1100 AUT 1636588 4815423
7 BAHNHOFSTRASSE LANGNAU IM EMMENTAL BERN 3550 CHE 778447 4693928
1 HASENBERG ALTSTADT SACHSEN 01067 DEU 1374604 5105173
3 PLACE DU 8 MAI 1945 SAULNES LORRAINE 54650 FRA 582300 4953234
As I was only interested in columns 1,2,4 and 5 and i wanted to reorganize it, I used the following awk command.
The above code has created the following output file.
Code:
COUNTRY POSTAL CITY ADDRESS1
DEU 83022 ROSENHEIM 32 PRINZREGENTENSTRASSE
ITA 70122 BARI 263 VIA DANTE ALIGHIERI
ITA 24047 TREVIGLIO 30 VIA MILANO
CHE 3423 ERSIGEN 2 KREUZWEG
ITA 00198 ROMA 28 VICOLO DELLA FONTANA
AUT 1100 10. BEZIRK-FAVORITEN 3 MUNCHPLATZ
CHE 3550 LANGNAU IM EMMENTAL 7 BAHNHOFSTRASSE
DEU 01067 ALTSTADT 1 HASENBERG
FRA 54650 SAULNES 3 PLACE DU 8 MAI 1945
However, when i open this file with excel on Windows and i specify it is a tab delimited file, The complete row is shown as a single column. Whereas in UNIX when i check this file with the following command It shows that there are 4 columns.
Code:
cat WEUM.dat | head -5 | awk -F"\t" '{print $3}'
Am I missing something, how to fix this. I use the output file as an input to some java program, I tried debugging the java program and found out that the total row is considered as a single column, instead of 4 columns
Hello,
I am trying to parse a file that resembles the last three groupings into something looking like the first two lines. I've fiddled with sed and awk a bit, but can't get anything to work properly. I need them separated by some delimiter. The file is some 23,000 lines of the stuff....
... (9 Replies)
Hi,
I have a small requirement where i need to sum up a column in a text file.
Input file
66ab 000000 534385 -00000106350.00
66cd 000000 534485 -00013364511.00
66ad 000000 534485 -00000426548.00
672a 000000 534485 000000650339.82... (5 Replies)
witam
potrzebuje polecenia porownujacego koumny na podstawie n-ostatnich znakow danej linnijki tj
mam 2 koumny AiB zawierajace ciag dowolnych znakow (dlugosci w kazdej linijce mga byc rozne wiec uzycie substra odpada)
A B
ewewewabc nbgujnnabc... (3 Replies)
Dear all,
I have a file in this format (like a matrix)
- A B C .. X
A 1 4 2 .. 2
B 2 6 4 .. 8
C 3 5 5 .. 4
. . . ... .
X . . ... .
and want to convert it into a file with this format:
A A = 1
A B = 4
A C = 2
...
A X = 2
B A = 2
B B = 6
etc (2 Replies)
hello all,
i have an input file like that
A A X0
A B X1
A C X2
...
A Z Xx
B A X1
B B X3
....
Z A Xx
Z B X4
and i want to have an output like that
A B C D
A X0 X1 X2 Xy
B X1 X3 X4 (4 Replies)
Dear users,
I have this problem, this is the example:
123 (tab) A (tab) B (tab) C (tab) 456
where the (tab) is actually the \t delimiter. I need to replace the A B and C for D E and F, this is:
123 (tab) D (tab) E (tab) F (tab) 456
The thing is that my file is quite long and this... (2 Replies)
Hello all,
I have a file which is tab separated like that:
PHE_205_A TIP_127_W ARG_150_B
MET_1150_A TIP_12_W VAL_11_B
GLU_60_A TIP_130_W ARG_143_B
LEU_1033_A TIP_203_W ARG_14_B
SER_1092_A TIP_203_W
THR_1090_A TIP_203_W
SER_1092_A TIP_25_W ... (6 Replies)
Hi,
I have a tab separated. I want to replace all the "&" in 8th column of the file with "and" .I am trying with
awk -F, -vOFS=\\t '{$8=($8=="&")?"and":$8}1' test> test1.txt
My file is abc def ghk hjk lkm hgb jkluy acvf & bhj hihuhu fgg
me mine he her go went has has & had hgf hgy
... (1 Reply)
Hi all,
I'm trying to read a tab separated file and apply some functions on each column. I have an issue with empty column.
Exemple:
$ #cat with the sed to allow you to see my tab
$ cat foo.txt| sed 's/\t/;/g'
a;1;x
b;;yI wanted to something like that:
while read col1 col2 col3
do
... (4 Replies)
In the gawk below, I am trying to output the file tab-deliminated but don't think that is the correct syntax. Thank you :).
gawk OFS='/t' '{sub(/-+/,"",$2); ar=$0}
END{n = asort(ar)
for (i = 1; i <= n; i++)
print ar}' file (2 Replies)
Discussion started by: cmccabe
2 Replies
LEARN ABOUT OSX
locale::codes::langfam
Locale::Codes::LangFam(3pm) Perl Programmers Reference Guide Locale::Codes::LangFam(3pm)NAME
Locale::Codes::LangFam - standard codes for language extension identification
SYNOPSIS
use Locale::Codes::LangFam;
$lext = code2langfam('apa'); # $lext gets 'Apache languages'
$code = langfam2code('Apache languages'); # $code gets 'apa'
@codes = all_langfam_codes();
@names = all_langfam_names();
DESCRIPTION
The "Locale::Codes::LangFam" module provides access to standard codes used for identifying language families, such as those as defined in
ISO 639-5.
Most of the routines take an optional additional argument which specifies the code set to use. If not specified, the default ISO 639-5
language family codes will be used.
SUPPORTED CODE SETS
There are several different code sets you can use for identifying language families. A code set may be specified using either a name, or a
constant that is automatically exported by this module.
For example, the two are equivalent:
$lext = code2langfam('apa','alpha');
$lext = code2langfam('apa',LOCALE_LANGFAM_ALPHA);
The codesets currently supported are:
alpha
This is the set of three-letter (lowercase) codes from ISO 639-5 such as 'apa' for Apache languages.
This is the default code set.
ROUTINES
code2langfam ( CODE [,CODESET] )
langfam2code ( NAME [,CODESET] )
langfam_code2code ( CODE ,CODESET ,CODESET2 )
all_langfam_codes ( [CODESET] )
all_langfam_names ( [CODESET] )
Locale::Codes::LangFam::rename_langfam ( CODE ,NEW_NAME [,CODESET] )
Locale::Codes::LangFam::add_langfam ( CODE ,NAME [,CODESET] )
Locale::Codes::LangFam::delete_langfam ( CODE [,CODESET] )
Locale::Codes::LangFam::add_langfam_alias ( NAME ,NEW_NAME )
Locale::Codes::LangFam::delete_langfam_alias ( NAME )
Locale::Codes::LangFam::rename_langfam_code ( CODE ,NEW_CODE [,CODESET] )
Locale::Codes::LangFam::add_langfam_code_alias ( CODE ,NEW_CODE [,CODESET] )
Locale::Codes::LangFam::delete_langfam_code_alias ( CODE [,CODESET] )
These routines are all documented in the Locale::Codes::API man page.
SEE ALSO
Locale::Codes
The Locale-Codes distribution.
Locale::Codes::API
The list of functions supported by this module.
http://www.loc.gov/standards/iso639-5/id.php
ISO 639-5 .
AUTHOR
See Locale::Codes for full author history.
Currently maintained by Sullivan Beck (sbeck@cpan.org).
COPYRIGHT
Copyright (c) 2011-2012 Sullivan Beck
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.16.2 2012-10-11 Locale::Codes::LangFam(3pm)