11-06-2019
yes
now i am getting required ouput.
Thanks so much for your help Rudic and vgersh99 .
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
if u have a data
2 4 6 8 5 4 4 5 6
then result shud be like
2
4
6
7
5
4
4
5
6 (3 Replies)
Discussion started by: cdfd123
3 Replies
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
Hi,
I have a file with below contents.
Heading1 Heading2 Heading3 Heading4
Value1 Value2 Value3 Value4
The file has only 2 rows and is tab separated
The desired output is :
Heading1 Value1
Heading2 Value2
Heading3 Value3
Heading4 Value4
CAn you please help? (5 Replies)
Discussion started by: kaponeh
5 Replies
4. Shell Programming and Scripting
Hi I have the text file like this
"A"
"AA Info"
"AA Text"
"AAA"
"ABC"
"ABC Info"
"ABC Tech"
"AGH"
"SYN"
"SYMBony"
"SYN BEREN"
Like about 2000 lines
Output would be in Column with groups like following
"A"
"AA Info", "AA Text"
"AAA"
"ABC","ABC Info","ABC Tech" (0 Replies)
Discussion started by: selvanraj
0 Replies
5. Shell Programming and Scripting
Dear All,
I have a data file input.csv like below. (Only five column shown here for example.)
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
3,2,4,5,6
5,3,5,5,6
From this I want the below output
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies
6. Shell Programming and Scripting
I have this file
103,7243534512111,NiaC1-02
105,720412845543550,NiaC2-00
105,720439254543351,NiaC200
105,720445724354315,Nia100
105,72044770454398,Nia100
105,720484154334546,Nia616
i want in this format
insert into aildump values(103,'7243534512111','NiaC1-02');
I'm able to... (3 Replies)
Discussion started by: nikhil jain
3 Replies
7. Shell Programming and Scripting
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)
Discussion started by: sai_2507
3 Replies
8. Shell Programming and Scripting
Convert Single column to multiple rows
file a.txt contains data like below
Server=abc
Run=1
Tables=10
Sessions=16
Time=380
Jobs=5
Server=abc
Run=2
Tables=15
Sessions=16
Time=400
Jobs=5
Server=abc
Run=3
Tables=20
Sessions=16
Time=450 (5 Replies)
Discussion started by: sol_nov
5 Replies
9. Shell Programming and Scripting
Hi,
I need help to convert rows in input file into a table.
inputfile
192.98.1 192.98.192.98.17 VVC family Zorro 10
192.98.1 192.98.192.98.17 VVC family Ace 1
192.98.1 192.98.192.98.17 VVC family ... (4 Replies)
Discussion started by: redse171
4 Replies
10. Shell Programming and Scripting
Hi,
I have a requirement to format the data in a new order. Here is my source format :
ppp ***Wed Dec 16 10:32:30 GMT 2015
header1 header2 header3 header4 header5
server1 0.00 0.02 0.07 0.98
server2 0.01 0.00 0.08 0.79
server3 0.05 0.82 0.77 0.86
... (18 Replies)
Discussion started by: john_prince
18 Replies
LEARN ABOUT CENTOS
db2ldif.pl
DB2LDIF.PL(8) System Manager's Manual DB2LDIF.PL(8)
NAME
db2ldif.pl - Directory Server perl script for exporting a database to a LDIF file
SYNOPSIS
db2ldif.pl [-Z serverID] [-D rootdn] { -w password | -w - | -j pwfilename } [-P protocol] {-n backendname}* | {-s includeSuffix}* [{-x
excludeSuffix}*] [-m] [-M] [-r] [-u] [-C] [-N] [-E] [-1] [-U] [-a filename] [-v] [-h]
DESCRIPTION
Exports the contents of the database to LDIF. This script creates an entry in the directory that launches this dynamic task.
OPTIONS
A summary of options is included below:
-Z Server Identifier
The server ID of the Directory Server instance. If there is only one instance on the system, this option can be skipped.
-D Root DN
The Directory Manager DN, or root DN. If not specified, the script will search the server instance configuration for the value.
-w password
The rootdn password.
-w -
Prompt for the rootdn password.
-j password filename
The name of the file that contains the root DN password.
-n Backend Name
The name of the LDBM database to restore. Example: userRoot
-s includeSuffix
The suffix DN to be included in the exported LDIF file.
-x excludeSuffix
The suffix DN to be excluded from the exported LDIF file.
-a filename
Name for the exported LDIF file.
-P Protocol
The connection protocol to connect to the Directory Server. Protocols are STARTTLS, LDAPS, LDAPI, and LDAP. If this option is
skipped, the most secure protocol that is available is used. For LDAPI, AUTOBIND is also available for the root user.
-m
Minimize the base64 encodings in the exported LDIF file.
-M
Exported ldif is stored in multiple files. These files are named : <instance>_<filename>
By default, all instances are stored in the filename specified by the -a option.
-r
Export replication data(information required to initialize a replica when the LDIF is imported).
-u
Do not export the unique-id attribute.
-U
Requests that the output LDIF is not folded.
-C
Uses only the main database file.
-N
Suppress printing sequential number
-E
Decrypts any encrypted data during export.
-1
Deletes, for reasons of backward compatibility, the first line of the LDIF file that gives the version of the LDIF standard.
-v
Display verbose ouput
-h
Display usage
EXAMPLE
db2ldif.pl -Z instance3 -n userRoot -a /LDAP/ldif/export.ldif -P STARTTLS
Note: security must be enabled to use protocol STARTTLS. If STARTTLS is not available it will default to next strongest/available
protocol automatically.
db2ldif.pl -s 'dc=example,dc=com' -a /LDAP/ldif/export.ldif -m -E -q
DIAGNOSTICS
Exit status is zero if no errors occur. Errors result in a non-zero exit status and a diagnostic message being written to standard error.
AUTHOR
db2ldif.pl was written by the 389 Project.
REPORTING BUGS
Report bugs to http://bugzilla.redhat.com.
COPYRIGHT
Copyright (C) 2013 Red Hat, Inc.
Mar 5, 2013 DB2LDIF.PL(8)