Sponsored Content
Top Forums Shell Programming and Scripting Checking required columns in the file Post 302570004 by muralikri on Wednesday 2nd of November 2011 08:29:17 AM
Old 11-02-2011
Checking required columns in the file

Hi,

File contains with TAB delimeter file,i want check the 2,3 are not null
Code:
test1@gmail.com  100 test
test2@gmail.com  101 test 
test3@gmail.com   test 
test4@gmail.com 102

OUTPUT
Code:
test1@gmail.com  100 test
test2@gmail.com  101 test

Please help me with one single command in unix.

Thanks,
Murali


Moderator's Comments:
Mod Comment Please use code tags <- click the link!

Last edited by zaxxon; 11-02-2011 at 09:44 AM.. Reason: code tags, see PM
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script required to convert rows to columns

Hi Friends, I have a log file as below siteid = HYD spc = 100 rset = RS_D_M siteid = DEL spc = 200 rset = RS_K_L siteid = DEL2 spc = 210 rset = RS_D_M Now I need a output like column wise as below. siteid SPC rset HYD 100 RS_D_M (2 Replies)
Discussion started by: suresh3566
2 Replies

2. Shell Programming and Scripting

grep required data from two columns

hello, I have output from a command and I need to filter some info out of that. I tried awk command but I can not grep what I am looking for: Following is the output and I need to capture "disabled" for each volume from first column and report: # vol status Volume State ... (2 Replies)
Discussion started by: za_7565
2 Replies

3. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help. (7 Replies)
Discussion started by: rdhanek
7 Replies

4. Shell Programming and Scripting

Checking the case of columns

Hi, Is there a function in awk or sed which will check the case of the columns. If my column 8 is in lower case then I want to change my column 10 data in lower case and vice versa. I know in awk we have tolower and toupper functions but can we manipulate the data based on the case ?? ... (3 Replies)
Discussion started by: mora
3 Replies

5. Shell Programming and Scripting

Checking the required columns in File

Hello Experts, File contains 10 columns with | delimeter. 1,3,4,5,7,9 columns are required columns means it should contains values. i need those records, rest of it will contain or not contain data. test1.txt: a@a.com|a|b|c|d|e|f|g|h|i |a|b|c|d|e|f|g|h|i b@b.com|a||c|d|e|f|g|h|i... (7 Replies)
Discussion started by: muralikri
7 Replies

6. Shell Programming and Scripting

Checking for ranges based on 2 columns

Hi, I have a file with 6 columns. I want to check if column 1 and 2 fall between column 5 and 6 I want to call them as "TRUE_genes" if not then call them as "FALSE_genes". I can do it for checking one column but how to mention about two columns. file1 110371373... (1 Reply)
Discussion started by: Diya123
1 Replies

7. Shell Programming and Scripting

Required help to print diff columns for 2 patterns using awk

Hi All, I need help for below scenario : I have a principals.xml_24092012backup file : cat principals.xml_24092012backup </user> <user username="eramire" password="2D393C01720749256303D204826A374D9AE9ABABBF8A"> <roleMapping rolename="VIEW_EVERYTHING"/> </user> ... (2 Replies)
Discussion started by: kiran_j
2 Replies

8. Shell Programming and Scripting

Checking the CSV File Columns

Hi All, i have a CSV file like below, col1 col2 col3 col4 col5 col6 col7 a1 a2 a3 a4 a5 a6 a7 b1 b2 b3 b4 b5 b6 b7 c1 c2 c3 c4 c5 c6 c7 d1 d2 d3 d4 d5 d6 d7 Col1,col2.. are the column names and... (1 Reply)
Discussion started by: dileep_d10
1 Replies

9. UNIX for Dummies Questions & Answers

Best Alternative for checking input parameter contains required value or not

Any good way to check if code has the required output # /sbin/sysctl net.ipv4.icmp_echo_ignore_broadcasts net.ipv4.icmp_echo_ignore_broadcasts = 1 /sbin/sysctl net.ipv4.icmp_echo_ignore_broadcasts | grep "= 1" net.ipv4.icmp_echo_ignore_broadcasts = 1 What I can think of is above, and it... (16 Replies)
Discussion started by: alvinoo
16 Replies

10. UNIX for Beginners Questions & Answers

How to print multiple required columns dynamically in a file using the header name?

Hi All, i am trying to print required multiple columns dynamically from a fie. But i am able to print only one column at a time. i am new to shell script, please help me on this issue. i am using below script awk -v COLT=$1 ' NR==1 { for (i=1; i<=NF; i++) { ... (2 Replies)
Discussion started by: balu1234
2 Replies
bup-restore(1)						      General Commands Manual						    bup-restore(1)

NAME
bup-restore - extract files from a backup set SYNOPSIS
bup restore [--outdir=outdir] [-v] [-q] DESCRIPTION
bup restore extracts files from a backup set (created with bup-save(1)) to the local filesystem. The specified paths are of the form /branch/revision/path/to/file. The components of the path are as follows: branch the name of the backup set to restore from; this corresponds to the --name (-n) option to bup save. revision the revision of the backup set to restore. The revision latest is always the most recent backup on the given branch. You can dis- cover other revisions using bup ls /branch. /path/to/file the original absolute filesystem path to the file you want to restore. For example, /etc/passwd. Note: if the /path/to/file is a directory, bup restore will restore that directory as well as recursively restoring all its contents. If /path/to/file is a directory ending in a slash (ie. /path/to/dir/), bup restore will restore the children of that directory directly to the current directory (or the --outdir). If the directory does not end in a slash, the children will be restored to a subdirectory of the current directory. See the EXAMPLES section to see how this works. OPTIONS
-C, --outdir=outdir create and change to directory outdir before extracting the files. -v, --verbose increase log output. Given once, prints every directory as it is restored; given twice, prints every file and directory. -q, --quiet don't show the progress meter. Normally, is stderr is a tty, a progress display is printed that shows the total number of files restored. EXAMPLE
Create a simple test backup set: $ bup index -u /etc $ bup save -n mybackup /etc/passwd /etc/profile Restore just one file: $ bup restore /mybackup/latest/etc/passwd Restoring: 1, done. $ ls -l passwd -rw-r--r-- 1 apenwarr apenwarr 1478 2010-09-08 03:06 passwd Restore the whole directory (no trailing slash): $ bup restore -C test1 /mybackup/latest/etc Restoring: 3, done. $ find test1 test1 test1/etc test1/etc/passwd test1/etc/profile Restore the whole directory (trailing slash): $ bup restore -C test2 /mybackup/latest/etc/ Restoring: 2, done. $ find test2 test2 test2/passwd test2/profile SEE ALSO
bup-save(1), bup-ftp(1), bup-fuse(1), bup-web(1) BUP
Part of the bup(1) suite. AUTHORS
Avery Pennarun <apenwarr@gmail.com>. Bup unknown- bup-restore(1)
All times are GMT -4. The time now is 02:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy