Sponsored Content
Top Forums Shell Programming and Scripting Remove certain column with numeric value Post 302785699 by radoulov on Tuesday 26th of March 2013 07:51:12 AM
Old 03-26-2013
With Perl (core modules):

Code:
perl -F, '-MScalar::Util qw(looks_like_number)' -lane'
  print if looks_like_number $F[4]
  ' infile

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

to remove space after numeric

I have a script that shows me the disk SPace used by different dir under my home dir: #!/bin/ksh cd /ednpdtu3/u01/pipe p1=`df -g | tail -1 | tr -s " " | cut -d " " -f2` echo "Total Disk Space of Home Dir is $p1 GB" p2=`df -g | tail -1 | tr -s " " | cut -d " " -f3` echo "Total Disk Space... (2 Replies)
Discussion started by: ali560045
2 Replies

2. Shell Programming and Scripting

Remove non numeric values from a variable

Hello all, I am working on a basic script but need a little help. Issue: I am running a SQL Query using sqlplus and a shell script. I have the output of the statement stored as variable $A. $A is set to "other text here 45678754 other text here". I need to strip all text except that numeric... (13 Replies)
Discussion started by: ownedthawte
13 Replies

3. Shell Programming and Scripting

sed/awk-adding numeric to a column

I have a txt file as follows Code: Oct 1 file1 4144 Oct 1 file23 5170 Oct 2 file5 3434 Oct 21 file56 2343 I need to add a new column by marking the right log file from current directory. For example populate like this. Please not in the second columt for "1" it has... (2 Replies)
Discussion started by: gubbu
2 Replies

4. Shell Programming and Scripting

How to check if a column is having a numeric value or not in a file?

Hi, I want to know, how we find out if a column is having a numeric value or not. For Example if we have a csv file as ASDF,QWER,GHJK,123,FGHY,9876 GHTY,NVHR,WOPI,623,HFBS,5386 we need to find out if the 4th and 6th column has muneric value or not. Thanks in advance Keerthan (9 Replies)
Discussion started by: keerthan
9 Replies

5. UNIX for Dummies Questions & Answers

How to remove numeric characters in the flat file

HI, can any one help me please .. i have flat file like qwer123rt ass3242ccf jjk654 kjh838ppp nhdg453ok hdkk34 i want remove numeric characters in the flat file i want output like this qwerrt assccf jjk kjhppp nhdgok hdkk help me... (4 Replies)
Discussion started by: rafimd1985
4 Replies

6. Shell Programming and Scripting

Sorting file based on a numeric column

Hi, I use UBUNTU 12.04. I have a file with this structure: Name 2 1245787 A G 12 14 12 14 .... Name 1 1245789 C T 13 12 12 12..... I would like to sort my file based on the second column so to have this output for example: Name 1 1245789 C T 13 12 12 12..... Name 2 1245787 A G 12 14... (4 Replies)
Discussion started by: Homa
4 Replies

7. UNIX for Advanced & Expert Users

Sort by second column numeric values

From googling and reading man pages I figured out this sorts the first column by numeric values. sort -g -k 1,1 Why does the -n option not work? The man pages were a bit confusing. And what if I want to sort the second column numerically? I haven't been able to figure that out. The file... (7 Replies)
Discussion started by: cokedude
7 Replies

8. Shell Programming and Scripting

Remove space from numeric value

Hello, I need help. I have xml file and there are one extra space on number <EpiReference>1 42345</EpiReference>. And of cource, the value change on every new file. I need remove space from that value what is in between <EpiReference> and </EpiReference>. How I can do that? This are example... (9 Replies)
Discussion started by: Jopsulainen
9 Replies

9. Shell Programming and Scripting

Average each numeric column

Hi all, Does anyone know of an efficient unix script to average each numeric column of a multi-column tab delimited file (with header) with some character columns. Here is an example input file: CHR RS_ID ALLELE POP1 POP2 POP3 POP4 POP5 POP6 POP7 POP8... (7 Replies)
Discussion started by: Geneanalyst
7 Replies

10. UNIX for Beginners Questions & Answers

Replace a numeric values in a certain column

Hi All, I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7 I tried awk '{gsub("8","7",$35)}1' infile > outfile ----> not working sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies
libapache2-mod-perl2-2.0.7::docs::api::ModPerl::Util(3pmUser Contributed Perl Documentatilibapache2-mod-perl2-2.0.7::docs::api::ModPerl::Util(3pm)

NAME
ModPerl::Util - Helper mod_perl Functions Synopsis use ModPerl::Util; # e.g. PerlResponseHandler $callback = ModPerl::Util::current_callback; # exit w/o killing the interpreter ModPerl::Util::exit(); # untaint a string (do not use it! see the doc) ModPerl::Util::untaint($string); # removes a stash (.so, %INC{$stash}, etc.) as best as it can ModPerl::Util::unload_package($stash); # current perl's address (0x92ac760 or 0x0 under non-threaded perl) ModPerl::Util::current_perl_id(); Description "ModPerl::Util" provides mod_perl utilities API. API
"ModPerl::Util" provides the following functions and/or methods: "current_callback" Returns the currently running callback name, e.g. 'PerlResponseHandler'. $callback = ModPerl::Util::current_callback(); ret: $callback ( string ) since: 2.0.00 "current_perl_id" Return the memory address of the perl interpreter $perl_id = ModPerl::Util::current_perl_id(); ret: $perl_id ( string ) Under threaded perl returns something like: 0x92ac760 Under non-thread perl returns 0x0 since: 2.0.00 Mainly useful for debugging applications running under threaded-perl. "exit" Terminate the request, but not the current process (or not the current Perl interpreter with threaded mpms). ModPerl::Util::exit($status); opt arg1: $status ( integer ) The exit status, which as of this writing is ignored. (it's accepted to be compatible with the core "exit" function.) ret: no return value since: 2.0.00 Normally you will use the plain "exit()" in your code. You don't need to use "ModPerl::Util::exit" explicitly, since mod_perl overrides "exit()" by setting "CORE::GLOBAL::exit" to "ModPerl::Util::exit". Only if you redefine "CORE::GLOBAL::exit" once mod_perl is running, you may want to use this function. The original "exit()" is still available via "CORE::exit()". "ModPerl::Util::exit" is implemented as a special "die()" call, therefore if you call it inside "eval BLOCK" or "eval "STRING"", while an exception is being thrown, it is caught by "eval". For example: exit; print "Still running"; will not print anything. But: eval { exit; } print "Still running"; will print Still running. So you either need to check whether the exception is specific to "exit" and call "exit()" again: use ModPerl::Const -compile => 'EXIT'; eval { exit; } exit if $@ && ref $@ eq 'APR::Error' && $@ == ModPerl::EXIT; print "Still running"; or use "CORE::exit()": eval { CORE::exit; } print "Still running"; and nothing will be printed. The problem with the latter is the current process (or a Perl Interpreter) will be killed; something that you really want to avoid under mod_perl. "unload_package" Unloads a stash from the current Perl interpreter in the safest way possible. ModPerl::Util::unload_package($stash); arg1: $stash ( string ) The Perl stash to unload. e.g. "MyApache2::MyData". ret: no return value since: 2.0.00 Unloading a Perl stash (package) is a complicated business. This function tries very hard to do the right thing. After calling this function, it should be safe to "use()" a new version of the module that loads the wiped package. References to stash elements (functions, variables, etc.) taken from outside the unloaded package will still be valid. This function may wipe off things loaded by other modules, if the latter have inserted things into the $stash it was told to unload. If a stash had a corresponding XS shared object (.so) loaded it will be unloaded as well. If the stash had a corresponding entry in %INC, it will be removed from there. "unload_package()" takes care to leave sub-stashes intact while deleting the requested stash. So for example if "CGI" and "CGI::Carp" are loaded, calling "unload_package('CGI')" won't affect "CGI::Carp". "untaint" Untaint the variable, by turning its tainted SV flag off (used internally). ModPerl::Util::untaint($tainted_var); arg1: $tainted_var (scalar) ret: no return value $tainted_var is untainted. since: 2.0.00 Do not use this function unless you know what you are doing. To learn how to properly untaint variables refer to the perlsec manpage. See Also mod_perl 2.0 documentation. Copyright mod_perl 2.0 and its core modules are copyrighted under The Apache Software License, Version 2.0. Authors The mod_perl development team and numerous contributors. perl v5.14.2 2011-02-08 libapache2-mod-perl2-2.0.7::docs::api::ModPerl::Util(3pm)
All times are GMT -4. The time now is 03:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy