Add values to file in 2 new columns Post: 303044033

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to flip values of two columns and add an extra column

Hi guys, Couldn't find the solution of this problem. Please Help! I have a file- Input_File TC200232 92 30 TC215306 2 74 TC210135 42 14 I want an output file in which if column2>column3, the values are swapped and an additional column with value Rev_Com is...

2. UNIX for Dummies Questions & Answers

combine the values from the first two columns within a file

Hello everybody, I have a text file containing 10,000 rows and 5000 columns. The values are separated by a tab. Ex. file_ex.ped 1 mike 0 0 2 1 A A G G C T A G 1 jack 0 0 2 2 T A G T C A A C 1 Mary 0 0 1 2 A T G C A T G C ... I would like a out put file 1 mike 0 0 2 1 AA GG CT AG 1...

3. Shell Programming and Scripting

Math operations with file columns values.

Hello everybody, I have some large files containing statistical data. The data is stored in the following generic format: >cat my_file 1, 2, 3 1, 2, 3 1, 2, 3 > The values of columns no.2 and 3 are expressed in bytes. I would like to transform them in Megabytes, by dividing them with...

4. Shell Programming and Scripting

Copy values from columns matching in those in second file.

Hi All, I have two sets of files. Set 1: 100 text files with extension .txt with names like 1.txt, 2.txt, 3.txt until 100.txt Set 2: One big file with extension .dat The text files have some records in columns like this: 0.7316431 82628 0.7248189 82577 0.7248182 81369 0.7222999...

5. UNIX for Dummies Questions & Answers

Subtracting values from 2 columns in a file

Hello, I have a file with 5 columns that looks like this: A1BG chr19 + 58863335 58866549 A1BG chr19 - 58858171 58864865 A2LD1 chr13 - 101182417 101186056 A2LD1 chr13 - 101182417 101241046 A2M chr12 - 9220303 9268558 A2ML1 ...

6. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing...

7. Shell Programming and Scripting

for uniq entries add values in corresponding columns

Hi, I have a file as listed below.. What I want to get is for each unique value in column 1 the corresponding values in the rest of the columns should be summed up.. AAK1 0 1 0 11 AAK1 0 0 1 1 AAK1 0 0 1 2...

8. Shell Programming and Scripting

Add the values in second and third columns with group by on first column.

Hi All, I have a pipe seperated file. I need to add the values in second and third columns with group by on first column. MYFILE_28012012_1115|47|173.90 MYFILE_28012012_1115|4|0.00 MYFILE_28012012_1115|6|22.20 MYFILE_28012012_1116|47|173.90 MYFILE_28012012_1116|4|0.00...

9. Shell Programming and Scripting

Add values in 2 columns and subtract from third

Hi All, I have a file with thousands of lines in the following format, where Field1=First 8 characters Field2-9-16 characters Field3=17-26 characters I need to add Field 1 and Field2 and subtract the result from Field 3. Field3=Field3 - (Field1 + Field2) 0012.00 0010.00 0001576.53...

10. UNIX for Beginners Questions & Answers

Awk: compare values in two columns of the same file

I'm trying to learn awk, but I've hit a roadblock with this problem. I have a hierarchy stored in a file with 3 columns: id name parentID 4 D 2 2 B 1 3 C 1 1 A 5 I need to check if there are any values in column 3 that are not represented anywhere in column 1. I've tried this: awk '{arr;}...

LEARN ABOUT DEBIAN

marc::lint::codedata

MARC::Lint::CodeData(3pm)				User Contributed Perl Documentation				 MARC::Lint::CodeData(3pm)

NAME

       MARC::Lint::CodeData -- Contains codes from the MARC code lists for Geographic Areas, Languages, and Countries.

DESCRIPTION

       Code data is used for validating fields 008, 040, 041, and 043.

       Also, sources for subfield 2 in 600-651 and 655.

       Stores codes in hashes, %MARC::Lint::CodeData::[name].

       Note: According to the official MARC documentation, Sears is not a valid 655

       term. The code data below treats it as valid, in anticipation of a change in

       the official documentation.

SYNOPSIS

       use MARC::Lint::CodeData;

       #Should provide access to the following:

       #%MARC::Lint::CodeData::GeogAreaCodes;

       #%MARC::Lint::CodeData::ObsoleteGeogAreaCodes;

       #%MARC::Lint::CodeData::LanguageCodes;

       #%MARC::Lint::CodeData::ObsoleteLanguageCodes;

       #%MARC::Lint::CodeData::CountryCodes;

       #%MARC::Lint::CodeData::ObsoleteCountryCodes;

       #%MARC::Lint::CodeData::Sources600_651;

       #%MARC::Lint::CodeData::ObsoleteSources600_651;

       #%MARC::Lint::CodeData::Sources655;

       #%MARC::Lint::CodeData::ObsoleteSources655;

       #or, import specific code list data

       use MARC::Lint::CodeData qw(%GeogAreaCodes);

       my $gac = "n-us---";

       my $validgac = 1 if ($GeogAreaCodes{$gac});

       print "Geographic Area Code $gac is valid
" if $validgac;

EXPORT

       None by default.

       @EXPORT_OK: %GeogAreaCodes, %ObsoleteGeogAreaCodes, %LanguageCodes, %ObsoleteLanguageCodes, %CountryCodes, %ObsoleteCountryCodes,
       %Sources600_651, %ObsoleteSources600_651, %Sources655, %ObsoleteSources655.

TO DO

       Update codes as needed (see <http://www.loc.gov/marc/>).

       Add other codes for MARC Code Lists for Relators, Sources, Description Conventions.

       Determine what to do about 600-655 codes with indicators (cash, lcsh, lcshac,

       mesh, nal, and rvm). Currently, these are duplicated in valid and obsolete

       hashes. Validation routines should probably treat these differently due to large

       numbers of records using these codes, created before the indicators were

       allowed.

       Determine whether three blank spaces should be in the LanguageCodes (for 008 validation) or not.

       If it is here, then 041 would be allowed to have three blank spaces as a valid code

       (though other checks would report the error--spaces at the beginning and ending of a subfield

       and multiple spaces in a field where such a thing is not allowed).

   SEE ALSO
       MARC::Lint

       MARC::Lintadditions (for check_040, check_041, check_043 using these codes)

       MARC::Errorchecks (for 008 validation using these codes)

       <http://www.loc.gov/marc/> for the official code lists.

       The following (should be included in the distribution package for this package):

       countrycodelistclean.pl

       gaccleanupscript.pl

       languagecodelistclean.pl

       The scripts above take the MARC code list ASCII version as input.

       They output tab-separated codes for updating the data below.

VERSION HISTORY

       Version 1.28: Updated May 2, 2009.

	-Added new sources codes from Technical Notice of Oct. 10, 2008.

	-Added new sources codes from Technical Notice of Dec. 16, 2008.

	-Added new language codes from Technical Notice of Jan. 6, 2009 (mol moved to ObsoleteLanguageCodes).

	-Added new sources codes from Technical Notice of Jan. 23, 2009.

	-Added new sources codes from Technical Notice of Feb. 19, 2009.

	-Added new sources codes from Technical Notice of Apr. 22, 2009.

       Version 1.27: Updated Aug. 14, 2008.

	-Added new sources codes from Technical Notice of July 25, 2008.

       Version 1.26: Updated July 6, 2008.

	-Added new language codes from Technical Notice of July 1, 2008.

	-Moved obsolete language codes 'scc' and 'scr' to the obsolete language hash.

       Version 1.25: Updated Apr. 28, 2008.

	-Added new sources codes from Technical Notice of Apr. 25, 2008.

       Version 1.24: Updated Mar. 30, 2008.

	-Added new sources codes from Technical Notice of Mar. 28, 2008.

       Version 1.23: Updated Mar. 26, 2008.

	-Added new country and GAC codes from Technical Notice of Mar. 25, 2008.

       Version 1.22: Updated Jan. 21, 2008.

	-Added new sources codes from Technical Notice of Jan. 18, 2008.

       Version 1.21: Updated Nov. 30, 2007.

	-Added new sources codes from Technical Notice of Nov. 30, 2007.

       Version 1.20: Updated Nov. 19, 2007.

	-Added new language codes from Technical Notice of Nov. 16, 2007.

       Version 1.19: Updated Oct. 22, 2007.

	-Added new language codes from Technical Notice of Oct. 22, 2007.

       Version 1.18: Updated Aug. 14, 2007.

	-Added new source codes from Technical Notice of Aug. 13, 2007.

       Version 1.17: Updated July 16, 2007.

	-Added new source codes from Technical Notice of July 13, 2007.

       Version 1.16: Updated Apr. 18, 2007.

	-Added new source codes from Technical Notice of Apr. 5, 2007.

       Version 1.15: Updated Feb. 28, 2007.

	-Added new country and geographic codes from Technical Notice of Feb. 28, 2007.

	-Added 'yu ' to list of obsolete codes.

       Version 1.14: Updated Jan. 8, 2007.

	-Added new source codes from Technical Notice of Jan. 5, 2007.

       Version 1.13: Updated Nov. 19, 2006.

	-Added new source codes from Technical Notice of Nov. 14, 2006.

       Version 1.12: Updated Oct. 20, 2006.

	-Added new source code from Technical Notice of Oct. 19, 2006.

       Version 1.11: Updated Oct. 18, 2006.

	-Added new source codes from Technical Notice of Oct. 17, 2006.

       Version 1.10: Updated Aug. 30, 2006.

	-Added new source codes from Technical Notice of Aug. 29, 2006.

       Version 1.09: Updated June 26, 2006.

	-Added new source codes from Technical Notice of June 23, 2006.

       Version 1.08: Updated May 30, 2006.

	-Added new source codes from Technical Notice of May 26, 2006.

       Version 1.07: Updated Mar. 13, 2006.

	-Added new source codes from Technical Notice of Mar. 10, 2006.

       Version 1.06: Updated Feb. 23, 2006.

	-Added new language codes from Technical Notice of Feb 23, 2006.

	-Alphabetized language codes.

       Version 1.05: Updated Jan. 11, 2006.

	-Added new sources codes from Technical Notice of Jan. 10, 2006.

       Version 1.04: Updated Oct. 13, 2005.

	-Added new sources codes from Technical Notice of Oct. 12, 2005.

       Version 1.03: Updated Aug. 31, 2005.

	-Added new language codes for Ainu and Southern Altai (August 30, 2005 technical notice)

       Version 1.02: Updated June 21-July 12, 2005. Released (to CPAN) with new version of MARC::Errorchecks.

	-Added GAC and Country code changes for Australia (July 12, 2005 update)

	-Added 6xx subfield 2 source code data for June 17, 2005 update.

	-Updated valid Language codes to June 2, 2005 changes.

       Version 1.01: Updated Jan. 5-Feb. 10, 2005. Released (to CPAN) Feb. 13, 2005 (with new version of MARC::Errorchecks).

	-Added code list data for 600-651 subfield 2 and for 655 subfield 2 sources.

	-Updated codes based on changes made Jan. 19 (languages), Feb. 2 (sources), Feb. 9 (sources).

       Version 1.00 (original version): First release, Dec. 5, 2004. Uploaded to SourceForge CVS, Jan. 3, 2005.

	-Included in MARC::Errorchecks distribution on CPAN.

	-Used by MARC::Lintadditions.

LICENSE

       This code may be distributed under the same terms as Perl itself.

       Please note that this module is not a product of or supported by the

       employers of the various contributors to the code.

AUTHOR

       Bryan Baldus

       eijabb@cpan.org

       Copyright (c) 2004-2008.

perl v5.10.0							    2009-09-01						 MARC::Lint::CodeData(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to flip values of two columns and add an extra column

Discussion started by: smriti_shridhar

2. UNIX for Dummies Questions & Answers

combine the values from the first two columns within a file

Discussion started by: Unilearn

3. Shell Programming and Scripting

Math operations with file columns values.

Discussion started by: fabian23

4. Shell Programming and Scripting

Copy values from columns matching in those in second file.

Discussion started by: shoaibjameel123