Sponsored Content
Top Forums Shell Programming and Scripting awk print specific columns one row at a time Post 302544028 by Corona688 on Tuesday 2nd of August 2011 05:27:15 PM
Old 08-02-2011
Quote:
Originally Posted by pr0tocoldan
Role_1_Name_Example; Role Description 1; DB Auth Profile 1; user1; 1; user1@DBG.ADS.DB.COM
Role_2_Name_Example; Role Description 2; DB Auth Profile 2; user2; 999; user2@DBG.ADS.DB.COM
Role_3_Name_Example; Role Description 3; DB Auth Profile 3; user3; 999; user3@DBG.ADS.DB.COM
Role_4_Name_Example; Role Description 4; DB Auth Profile 4; user4; 1; user4@DBG.ADS.DB.COM
Role_5_Name_Example; Role Description 5; DB Auth Profile 5; user5; 1; user5@DBG.ADS.DB.COM
Great, now please answer the other half of my question:
Quote:
Originally Posted by Corona688
...and what data from it do you want?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert a text from a specific row into a specific column using SED or AWK

Hi, I am having trouble converting a text file. I have been working for this whole day now, still i couldn't make it. Here is how the text file looks: _______________________________________________________ DEVICE STATUS INFORMATION FOR LOCATION 1: OPER STATES: Disabled E:Enabled ... (5 Replies)
Discussion started by: Issemael
5 Replies

2. Shell Programming and Scripting

shell script(Preferably awk or sed) to print selected number of columns from each row

Hi Experts, The question may look very silly by seeing the title, but please have a look at it clearly. I have a text file where the first 5 columns in each row were supposed to be attributes of a sample(like sample name, number, status etc) and the next 25 columns are parameters on which... (3 Replies)
Discussion started by: ks_reddy
3 Replies

3. Shell Programming and Scripting

Print columns from each row

I have awk command to print column 8 awk '/select/ {print $8}' which will print column 8 But I need to print 3, 5 and 8 column in a row and each column should be de-limited by "\t" Hope anyone help me quickly. (2 Replies)
Discussion started by: elamurugu
2 Replies

4. Shell Programming and Scripting

Need awk help to print specific columns with as string in a header

awk experts, I have a big file of 4000 columns with header. Would like to print the columns with string value of "Commands" in header. File has "," separator. This file is on ESX host with Bash. Thanks, Arv (21 Replies)
Discussion started by: arv_cds
21 Replies

5. Shell Programming and Scripting

awk compare specific columns from 2 files, print new file

Hello. I have two files. FILE1 was extracted from FILE2 and modified thanks to help from this post. Now I need to replace the extracted, modified lines into the original file (FILE2) to produce the FILE3. FILE1 1466 55.27433 14.72050 -2.52E+03 3.00E-01 1.05E+04 2.57E+04 1467 55.27433... (1 Reply)
Discussion started by: jm4smtddd
1 Replies

6. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Is it possible to remove redundant names in the 4th column? input cqWE 100 200 singapore;singapore AZO 300 400 brazil;america;germany;ireland;germany .... .... output cqWE 100 200 singapore AZO 300 400 brazil;america;germany;ireland (4 Replies)
Discussion started by: quincyjones
4 Replies

7. Shell Programming and Scripting

Grep and print only certain columns from a row

Hi Friends, This is my input chr1 100 200 + gene_name "alpha"; protein_name "alpha"; level 2; tag "basic"; info "known"; chr1 245 290 + gene_name "alpha-1"; protein_name "alpha-2"; level 9; tag "basic"; info "uknown"; chr1 310 320 + gene_name "alpha"; protein_name "alpha-4"; level 2; info... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

8. Shell Programming and Scripting

Match columns and print specific field

Hello, I have data in following format. ... (6 Replies)
Discussion started by: Pushpraj
6 Replies

9. Shell Programming and Scripting

Convert Second Column Date Into EPOCH Time And Print Complete Row

Hello Team, I am stuck in getting the required output in the following case. Please help. My input file is aa|08/01/2016 bb|08/15/2016 I wish to convert the file into aa|epoch time bb|epoch time I am using following code: (3 Replies)
Discussion started by: angshuman
3 Replies

10. Shell Programming and Scripting

Using awk to change a specific column and in a specific row

I am trying to change the number in bold to 2400 01,000300032,193631306,190619,0640,1,80,,2/ 02,193631306,000300032,1,190618,0640,CAD,2/ I'm not sure if sed or awk is the answer. I was going to use sed and do a character count up to that point, but that column directly before 0640 might... (8 Replies)
Discussion started by: juggernautjoee
8 Replies
Auth(3pm)						User Contributed Perl Documentation						 Auth(3pm)

NAME
X11::Auth - Perl module to read X11 authority files SYNOPSIS
require X11::Auth; $a = new X11::Auth; ($auth_type, $auth_data) = $a->get_by_host($host, $disp_num); DESCRIPTION
This module is an approximate perl replacement for the libXau C library and the xauth(1) program. It reads and interprets the files (usually '~/.Xauthority') that hold authorization data used in connecting to X servers. Since it was written mainly for the use of X11::Protocol, its functionality is currently restricted to reading, not writing, of these files. METHODS
new $auth = X11::Auth->new; $auth = X11::Auth->open($filename); Open an authority file, and create an object to handle it. The filename will be taken from the XAUTHORITY environment variable, if present, or '.Xauthority' in the user's home directory, or it may be overridden by an argument. 'open' may be used as a synonym. get_one ($family, $host_addr, $display_num, $auth_name, $auth_data) = $auth->get_one; Read one entry from the file. Returns a null list at end of file. $family is usually 'Internet' or 'Local', and $display_num can be any string. get_all @auth_data = $auth->get_all; Read all of the entries in the file. Each member of the array returned is an array ref similar to the list returned by get_one(). get_by_host ($auth_name, $auth_data) = $auth->get_by_host($host, $family, $display_num); Get authentication data for a connection of type $family to display $display_num on $host. If $family is 'Internet', the host will be translated into an appropriate address by gethostbyname(). If no data is found, returns an empty list. COMPATIBILITY
The following table shows the (rough) correspondence between libXau calls and X11::Auth methods: libXau X11::Auth ------ --------- XauFileName $ENV{XAUTHORITY} || "$ENV{HOME}/.Xauthority" fopen(XauFileName(), "rb") $auth = new X11::Auth XauReadAuth $auth->get_one XauWriteAuth XauGetAuthByAddr $auth->get_by_host XauGetBestAuthByAddr XauLockAuth XauUnlockAuth XauDisposeAuth AUTHOR
Stephen McCamant <SMCCAM@cpan.org> SEE ALSO
perl(1), X11::Protocol, Xau(3), xauth(1), lib/Xau/README in the X11 source distribution. perl v5.14.2 2006-01-19 Auth(3pm)
All times are GMT -4. The time now is 05:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy