I need to modify this script line again due to the requirements:
I need to create multiple CSV lines that user depending on that user's allowed capabilities. Ex:
Code:
Account name: bkpuser1
Role: backup
Description: Backup User
Allowed Capabilities: backup, restores, Create jobs -- Some users have more than 5 capabilities
Enabled: Yes
Account Name, Role, Description, Allowed Capabilities, Enabled
bkpuser1,backup,Backup user,backup,Enabled
bkpuser1,backup,Backup user,restores,Enabled
bkpuser1,backup,Backup user,Create Jobs,Enabled
......other users.
So I am trying to modify Franklyn's code:
Code:
awk -F":" 'BEGIN{print " Name, Info, Rid, Groups, Allowed Capabilities, Status"}{split ($8,a,","); for (i in length(a)) (print $2","$4","$6","$8","a[i]","$16} )' RS= mytxt2
What am I doing wrong here?
Thanks a bunch
Last edited by Franklin52; 06-12-2012 at 03:47 AM..
Reason: Please use code tags
Hi guys
Could anyone advise me how to convert my rows into columns from a file
My file would be similar to this:
A11 A12 A13 A14 A15 ... A1n
A21 A22 A23
A31
A41
A51
...
Am1 Am2 Am3 Am4 Am5 ... Amn
The number of rows is not the same to the number of columns
Thanks in advance (2 Replies)
Hi Gurus,
How to convert rows in to columns using linux shell scripting
Input is like (sample.txt)
ABC
DEF
GHI
JKL
MNO
PQR
STU
VWX
YZA
BCD
output should be (sampleoutput.csv)
ABC,DEF,GHI,JKL,MNO
PQR,STU,VWX,YZA,BCD (2 Replies)
Hi Everyone,
Could someone shed some lights on how to convert the records in rows form into column basis.
172.29.59.12
IBM,8255-E8B
102691P
8
65536 MB
6100-04-11-1140
172.29.59.15
IBM,8255-E8B
102698P
4
45056 MB
6100-04-11-1140
IP SYS MODEL ... (6 Replies)
I am looking to print the data in columns and after every 3 words it should be a new row.
cat example.out | awk 'END { for (i = 0; ++i < m;) print _;print _ }{ _ = _ x ? _ OFS $1 : $1}' m=1| grep -i INNER
I am looking to print in a new line after every 3 words.
... (2 Replies)
Hi Experts,
I have a requirement to convert rows into columns.
For e.g.
Input File:
Output File should be like
Appreciate if you could suggest code snippet(may be awk) for above requirement...
Thanks in Advance for your help... (3 Replies)
I want to put the 3 first lines into a single line separated by ;
I've tried to use Sed and Awk but without success. I'm new to Shell scripting.
Thanks in advance!
Input
112
DESAC_201309_OR_DJ10
DJ10
1234567890123;8
1234567890124;20
1234567890125;3
expected Output... (8 Replies)
hi folks,
I have a sample data like what is shown below:
1,ID=1000
1,Org=CedarparkHospital
1,cn=john
1,sn=doe
1,uid=User001
2,uid=User002
2,ID=2000
2,cn=steve
2,sn=jobs
2,Org=Providence
I would like to convert it into the below format:
1,1000,CedarparkHospital,john,doe,User001... (11 Replies)
Discussion started by: vskr72
11 Replies
LEARN ABOUT OSF1
bdb.db0
BDB.DB0(5) AFS File Reference BDB.DB0(5)NAME
bdb.DB0, bdb.DBSYS1 - Contain the Backup Database and associated log
DESCRIPTION
The bdb.DB0 file contains the Backup Database, which records configuration information used by the AFS Backup System along with cross-
indexed records of the tapes created and volumes dumped using the Backup System commands.
The bdb.DBSYS1 file is a log file in which the Backup Server (buserver process) logs each database operation before performing it. When an
operation is interrupted, the Backup Server replays the log to complete the operation.
Both files are in binary format and reside in the /var/lib/openafs/db directory on each database server machine that runs the Backup
Server. When the Backup Server starts or restarts on a given machine, it establishes a connection with its peers and verifies that its
copy of the bdb.DB0 file matches the copy on the other database server machines. If not, the Backup Servers use AFS's distributed database
technology, Ubik, to distribute to all of the machines the copy of the database with the highest version number.
Use the commands in the backup suite to administer the Backup Database. It is advisable to create a backup copy of the bdb.DB0 file on tape
on a regular basis, using the UNIX tar command or another local disk backup utility.
SEE ALSO backup(8), backup_savedb(8), buserver(8)COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 BDB.DB0(5)
06-11-2012
