Sponsored Content
Full Discussion: select a column
Top Forums Shell Programming and Scripting select a column Post 302205699 by alfreale on Monday 16th of June 2008 06:08:25 AM
Old 06-16-2008
select a column

I've a file like this:

andrea andre@lol.com october
antonio@lol.com
marco 45247@pop.com
kk@pop.com may
pollo@lol.com
mary mary@lol.com

can I select only the column with email adress?

can I utilise a filter with @ ?

I want obtain this:

andre@lol.com,antonio@lol.com,45247@...,pollo@lol.com,mary mary@lol.com

Alfredo
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Select Record based on First Column

Hi, I have a file with multiple records...and I have to select records based on first column....here is the sample file... I01,abc,125,1a2,LBVI02 I01,abc,126,2b5,LBVI02 I02,20070530,254,abc,LLBI01 I02,20070820,111,bvd,NGBI01 I need all records with I01 in first field in one file and... (8 Replies)
Discussion started by: mgirinath
8 Replies

2. UNIX for Dummies Questions & Answers

select first column of file

Hi, Following is my file output 247 Sleep 25439 NULL 259 Sleep 25460 NULL 277 Sleep 15274 NULL 361 Sleep 2 NULL 362 Sleep 202 NULL I want to select only first column to other file How can... (2 Replies)
Discussion started by: kaushik02018
2 Replies

3. Shell Programming and Scripting

How to select and edit on a particular column?

How can I use awk to pick a particular column and work on it? For example, I want to count the number of characters in column10 that are separated by |? Thank you. (2 Replies)
Discussion started by: ivpz
2 Replies

4. Shell Programming and Scripting

SQL select all but not if it is already in an other column

I know I know.. for sure one of the easier mysql statements. But somehow I can not figure out this. I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row) data_12 ... (6 Replies)
Discussion started by: lowmaster
6 Replies

5. UNIX for Dummies Questions & Answers

to select according to the second column..!!

the input is : 6298 | anna | chennai | 7/4/08 3981 | dastan | bagh | 8/2/07 6187 | galma | london | 9/5/01 3728 | gonna | kol | 8/2/10 3987 | hogja | mumbai | 8/5/09 2898 | homy | pune | 7/4/09 9167 | tamina | ny | 8/3/10 4617 | vazir | ny now how to get the following output : 3987 |... (4 Replies)
Discussion started by: adityamitra
4 Replies

6. Programming

select value from 'value' column if the Value2 is having a particular value.

Two columns are there in a table Value and Value2.I need to select a desired value from 'value' column if the Value2 is having a particular value. Ex. Table has values ---------------------------- Value Value2 ---------------------------- 1 GOD ... (6 Replies)
Discussion started by: gameboy87
6 Replies

7. Shell Programming and Scripting

select last column

Hi! From a file the format of whichis as in the sample here below, I need to get two files having just 2 columns, being - for the first file - the 2nd than the 1st from the original file; and - for the second file - the LAST then the 1st column of the original file. Moreover, I would sort the... (3 Replies)
Discussion started by: mjomba
3 Replies

8. Shell Programming and Scripting

To select only column starting with a particular value

Hi all, Am using awk to reformat an existing file cat $INP_FILE1 | while read line do echo "$line" | nawk ' BEGIN {FS=","} {print("5",$1,$28,"$27",$26)}' >> $OUT_FILE1 done my question is, i would like to read lines that are starting with particular value only example ... (9 Replies)
Discussion started by: selvankj
9 Replies

9. Shell Programming and Scripting

Select record having different value in second column

I want records which have more than one and different value in the second column on the below sample file. Ex, I have the samle file below :- XYZ 1 XYZ 3 abc 1 abc 1 qwe 2 qwe 1 qwe 3 I want to select XYZ and QWE line only. (6 Replies)
Discussion started by: Sanjeev Yadav
6 Replies

10. Shell Programming and Scripting

SELECT and wrapping to next column

Hi all, Am trying to write a menu driven script using SELECT and if I have more than 4 options, it wraps to the next column. That is if I have 6 choices, items 5 and 6 are in the second column. Is there any settings that control this behavior or is it due to some stty settings? stty -a... (3 Replies)
Discussion started by: newbie_01
3 Replies
icapnotify(1M)															    icapnotify(1M)

NAME
icapnotify - Test email connectivity to HP for Instant Capacity (iCAP) systems. Request a confirmation response email from HP. Turn config- uration change notification and asset reporting on or off. SYNOPSIS
icapnotify <reply_address> icapnotify -a on|off icapnotify -n on|off Obsolescent: icod_notify <reply_address> icod_notify -a on|off icod_notify -n on|off DESCRIPTION
When a reply_address is specified, sends an asset report via email to HP, root, and the specified email address. Confirmation email is sent from HP to the specified reply email address indicating that HP received the asset report email. Note that asset reporting is optional but can be useful for viewing complexwide asset information at the HP Utility Pricing Solutions por- tal (http://www.hp.com/go/icap/portal). The deprecated command provides identical functionality to the command and is maintained for backward compatibility. For detailed information on email configuration and requirements, see the located at /usr/share/doc/icapUserGuide.pdf. Options The command recognizes these options and arguments: -a on|off Turns email asset reporting on or off. This option is used to specify if the Instant Capacity software should send asset reports to HP via email. The command displays the present setting for this option. -n on|off Turns configuration change notification on or off. If specified on, executing the command results in a configuration change notification email sent to the system contact email address summarizing any configuration change. Configuration change notification email can be turned off by specifying off. Configuration change notifications are not sent if the system contact email address is not set. EXTERNAL INFLUENCES
Environment Variables o LANG determines the locale to use for the locale categories when both LC_ALL and the corresponding environment variable (begin- ning with LC_) do not specify a locale. If LANG is not set or is set to the empty string, a default of C is used (see lang(5)). o LC_CTYPE determines the interpretation of single- and multiple-byte characters. o LC_MESSAGES determines the language in which messages are displayed. If any internationalization variable contains an invalid setting, icapnotify behaves as if all internationalization variables are set to C (see environ(5)). International Code Set Support Single- and multiple-byte character code sets are supported. RETURN VALUE
The command exits with one of these values: 0 Command succeeded. >0 Command failed; error message sent to STDERR. EXAMPLES
Test email connectivity with HP by sending an asset report to HP, root , and super_user@corp.com, and request a confirmation email from HP to be sent to super_user@corp.com: icapnotify super_user@corp.com Turn email asset reporting on: icapnotify -a on Turn email asset reporting off: icapnotify -a off Turn configuration change notification on: icapnotify -n on Turn configuration change notification off: icapnotify -n off AUTHOR
was developed by HP. SEE ALSO
icapmodify(1M), icapstatus(1M), icapmanage(1M), icapd(1M), icap(5). icapnotify(1M)
All times are GMT -4. The time now is 08:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy