Sponsored Content
Top Forums Shell Programming and Scripting Remove certain column with numeric value Post 302785629 by zaxxon on Tuesday 26th of March 2013 04:49:54 AM
Old 03-26-2013
Can try if this is sufficient:
Code:
$ awk -F, '$5 !~ /[a-zA-Z]/' infile
LBP298W2,300,-18,-115,-12,-105
LBP298W3,300,-18,-115,-12,-105

 

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
Gnome(3)						User Contributed Perl Documentation						  Gnome(3)

NAME
Gnome - Perl module for the Gnome libraries SYNOPSIS
use Gnome; Gnome->init('myapp'); my $app = new Gnome::App("myapp", "myapp window title"); $app->create_menus({type => 'subtree', label => '_File', subtree => [ ['item', '_Quit', undef, sub {exit}, 'stock', 'Quit'], ]}); my $canvas = new Gnome::Canvas; $canvas->set_scroll_region(0, 0, 300, 300); $canvas->set_usize(300, 300); $canvas->root->new($canvas->root, 'Rect', x1 => 10, y1 => 10, x2 => 150, y2 => 250, fill_color => '#0f0ef2', outline_color => 'black'); $app->set_contents($canvas); $app->show_all; Gtk->main; DESCRIPTION
The Gtk module allows Perl access to the widgets and other facilities in the Gnome libraries. You can find more information about Gnome on http://www.gnome.org. The Perl binding tries to follow the C interface as much as possible, providing at the same time a fully object ori- ented interface and Perl-style calling conventions. You will find the reference documentation for the Gnome module in the "Gnome::reference" manpage. More information can be found on http://gtkperl.org. AUTHOR
Kenneth Albanowski, Paolo Molaro SEE ALSO
perl(1), Gtk(3pm), Gtk::reference(3pm), Gnome::reference(3pm) perl v5.8.0 2001-06-26 Gnome(3)
All times are GMT -4. The time now is 03:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy