Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: [Solved] Extract First character in fourth column
Top Forums Shell Programming and Scripting [Solved] Extract First character in fourth column Post 302888311 by Yoda on Thursday 13th of February 2014 07:11:53 PM
Old 02-13-2014
Use regexp comparison operator:
Code:
awk '$4~/^5/' file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to extract first column with a specific character

Hi All, Below is the sample data of my files: O|A|571000689|D|S|PNH|S|SI sadm|ibscml1x| I|A|571000689|P|S|PNH|S|SI sadm|ibscml1x| O|A|571000689|V|S|PNH|S|SI sadm|ibscml1x| S|C|CAM|D|S|PNH|R|ZOA|2004 bscml1x| ... (3 Replies)
Discussion started by: selamba_warrior
3 Replies

2. Shell Programming and Scripting

How to manipulate first column and reverse the line order in third and fourth column?

How to manipulate first column and reverse the line order in third and fourth column as follws? For example i have a original file like this: file1 0.00000000E+000 -1.17555359E-001 0.00000000E+000 2.00000000E-002 -1.17555359E-001 0.00000000E+000 ... (1 Reply)
Discussion started by: Max Well
1 Replies

3. Shell Programming and Scripting

Use awk to have the fourth column with spaces

Hi Gurus, We have a ftpserver from which we do a dir command and output it to a local file. The content of the ftpfile is: 07-15-09 06:06AM 5466 ABC_123_ER19057320090714082723.ZIP 07-15-09 06:07AM 3801 ABC_123_ER19155920090714082842.ZIP 07-15-09 06:07AM ... (14 Replies)
Discussion started by: donisback
14 Replies

4. Emergency UNIX and Linux Support

[Solved] Extract records based on a repeated column value

Hi guys, I need help in making a command to find some data. I have multiple files in which multiple records are present.. Each record is separated with a carriage return and in each record there are multiple fields with each field separated by "|" what i want is that I want to extract... (1 Reply)
Discussion started by: m_usmanayub
1 Replies

5. Shell Programming and Scripting

replace by match on fourth column

Hi friends, My input file is this way chr1 100 200 "abc" chr1 350 400 "abc" chr2 450 600 "def" chr2 612 780 "def" How do I make this file into chr1 100 400 "abc" chr2 450 780 "def" This is basically matching on the fourth column and taking the minimum of second column and the... (4 Replies)
Discussion started by: jacobs.smith
4 Replies

6. UNIX for Dummies Questions & Answers

[Solved] Deleting all rows where the first column equals the second column

Hi, I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks! Input: 1 1 ABC DEF 2 2 IJK LMN 1 2 ZYX OPW Output: 1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
2 Replies

7. Shell Programming and Scripting

[Solved] Sorting a column based on another column

hello, I have a file as follows: F0100010 A C F0100040 A G BTA-28763-no-rs 77.2692 F0100020 A G F0100030 A T BTA-29334-no-rs 11.4989 F0100030 A T F0100020 A G BTA-29515-no-rs 127.006 F0100040 A G F0100010 A C BTA-29644-no-rs 7.29827 F0100050 A... (9 Replies)
Discussion started by: Homa
9 Replies

8. Shell Programming and Scripting

Remove the first character from the fourth column only if the column has four characters

I have a file as follows ATOM 5181 N AMET K 406 12.440 6.552 25.691 0.50 7.37 N ATOM 5182 CA AMET K 406 13.685 5.798 25.578 0.50 5.87 C ATOM 5183 C AMET K 406 14.045 5.179 26.909 0.50 5.07 C ATOM 5184 O MET K... (14 Replies)
Discussion started by: hasanabdulla
14 Replies

9. Shell Programming and Scripting

[Solved] Replace character in 3rd column and leave 1rst and last

Hello to all, I have the following text where columns are separated by spaces. I want to have the 3rd column separating 3 strings with 2 "_" in the format below: LeftSring_CentralString_RightString So, in 3rd column I want to replace all "_" with "-", except the first and last "_" The... (5 Replies)
Discussion started by: Ophiuchus
5 Replies

10. Shell Programming and Scripting

Extract First character in Second column

Hi, I need to extract the first character of second column of my file. If the condition matches, then I need to print the 2nd and 3rd column as my output I tried below mentioned query but it was not working awk -F'|' '$2~/^5/' Sgn_group.txt File Name : Sgn_group.txt country... (2 Replies)
Discussion started by: suresh_target
2 Replies

LEARN ABOUT DEBIAN

pclock

PCLOCK(1)						      General Commands Manual							 PCLOCK(1)

NAME

       pclock - pixmap clock

SYNOPSIS

       pclock [options]

DESCRIPTION

       This  manual  page  documents  briefly  the pclock command.  This manual page was written for the Debian GNU/Linux distribution because the
       original program does not have a manual page.

       pclock is a program that places a small analog clock program on the desktop of X.  It was designed to run under the WindowMaker window man-
       ager.  It uses any 64x64 pixmap as a background.

OPTIONS

       The programs follow the usual GNU command line syntax, with long options starting with two dashes (`-') and short optoins starting with one
       dash.  A summary of options is included below.

       -B PIXMAP, --background=PIXMAP
	      Use the given pixmap as the clock background (size must be 64x64).

       -H COLOR, --hands-color=COLOR
	      Draw the hands (hour, minute and second) in the specified color.

       -S COLOR, --second-hand-color
	      Draw the second hand in the specified color

       -h, --help
	      Show summary of options.

       --hour-hand-length=INT
	      Draw the hour hand with the specified length of INT.

       --minute-hand-length=INT
	      Draw the minute hand with the specified length of INT.

       --second-hand-length=INT
	      Draw the second hand with the specified length of INT.

       --second-hand-width=INT
	      Draw the minute hand with the specified width of INT.

       -s, --second-hand
	      Don't display the second hand.

       -v, --version
	      Show version of program.

       -w, --withdrawn
	      Don't start up in a withdrawn (iconic) state.

AUTHOR

       This manual page was written by Darren Benham <gecko@debian.org>, for the Debian GNU/Linux system (but may be used by others).	The  soft-
       ware is copyrighted (c) 1998 by and released under the GPL v2.

       Author: Alexander Kourakos <Alexander@Kourakos.com>
	  Web: http://www.kourakos.com/~awk/pclock/

																	 PCLOCK(1)
All times are GMT -4. The time now is 10:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy