Bring values in the second column into single line (comma sep) for uniq value in the first column
I want to bring values in the second column into single line for uniq value in the first column.
My input
Expecting this output
I could get result using below code,, but I do not like it. There got to be better way of doing this using awk/sed/perl one liner.
Moderator's Comments:
Don't modify posts after people have reacted to it, pulling the rug from under them
Last edited by RudiC; 08-29-2016 at 11:10 AM..
Reason: correcting input
I have a file with
aaa,bbb,ccc,dddd,eee,xyz
aaa,bbb,ccc,dddd,eee,xyz,12345,rty
aaa,bbb,ccc,dddd,eee,xyz,12345,rty,tsrt
1. line columns are not fixed
2. all words are seperated by comma
what i want is always the string after last comma.
regards,
Senthil... (9 Replies)
I have a requirement in which i have to read a file which has multiple columns seperated by a pipe "|" from this i have to read each column values seperately and create a comma seperated row for the column and write to another file.
eg:
Input file:
ColA ColB
1 2
2 x
3 y... (5 Replies)
Hi,
I have a table in Db2 with data say
id_1 phase1
id_1 phase2
id_1 phase3
id_2 phase1
id_2 phase2
I need to concatenate the values like
id_1 phase1,phase2,phase3
id_2 phase1,phase2
I tried recursive query but in vain as the length of string to be concatenated in quite long. ... (17 Replies)
Hi,
I am new to shell scripting, i have requirement can any one help me out in this regrads,
in directory i have file like invoice1.txt, invoice2.txt in each file i have fixed number of columns, 62 in number but they are randomly arranged.like
for first file invoice1.txt can have columns... (5 Replies)
Hi,
I have a requirement with,
No~Dt~Notes
1~2011/08/1~"aaa
bbb
ccc
ddd
eee
fff
ggg
hhh"
Single column alone got splitted into multiple lines.
I require the output as
No~Dt~Notes
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh"
mean to say those new lines to be... (1 Reply)
Hi ,
Can You Please let Know How use unix uniq command on a single column for deleting records from file
with Below Structure.Pipe Delimter File .
Source
Name | Account_Id
A | 101
B... (2 Replies)
Hey guys, I have a column that consists of string and integer values without a distinctive deliminator, looking like this...
7ASA
14LAL
245FOO
656MOM
87577DAD
...
I want to split the column into two columns, one containing the numbers and one containing the text part.
edit: numbers... (3 Replies)
Hi,
I have pipe separated file which contains some data having comma(,) in it. I want to remove the comma(,) only from particular column without changing data in other columns.
Below is the sample data file, I want to remove the comma(,) only from 5th column.
$ cat file1
ABC | DEF, HIJ|... (6 Replies)
Hello everyone,
i need to replace in the second column of my csv file, points by nothing and dash by comma like this:
Input:
1 2 1;12.111.312-2;1.2;2;1-3
2 1 1;11.212.331-1;3.3;1;2-2
Output:
1 2 1;12111312;2;1.2;2;1-3
2 1 1;11212331;1;3.3;1;2-2
SED or PERL commands preferably.
... (7 Replies)
Hi All,
I am trying to output uniq values per column. see file below. can you please assist? Thank you in advance.
cat names
joe allen ibm
joe smith ibm
joe allen google
joe smith google
rachel allen google
desired output is:
joe allen google
rachel smith ibm (5 Replies)
Discussion started by: Apollo
5 Replies
LEARN ABOUT MOJAVE
wsgen
wsgen(1) General Commands Manual wsgen(1)NAME
wsgen - JAX-WS 2.0
SYNOPSIS
wsgen [options] SEI
DESCRIPTION
The wsgen tool generates JAX-WS portable artifacts used in JAX-WS web services. The tool reads a web service endpoint implementation class
(SEI) and generates all the required artifacts for web service deployment, and invocation.
OPTIONS -classpath path
Specify where to find input class files
-cp path
Same as -classpath
-d directory
Specify where to place generated output files
-extension
allow vendor extensions (functionality not specified by the specification). Use of extensions may result in applications that are
not portable or may not interoperate with other implementations.
-help Display help
-keep Keep generated files
-r directory
Used only in conjunction with the -wsdl option. Specify where to place generated resource files such as WSDLs.
-s directory
Specify where to place generated source files
-verbose
Output messages about what the compiler is doing
-version
Print version information. Use of this option will ONLY print version information. Normal processing will not occur.
-wsdl[:protocol]
By default wsgen does not generate a WSDL file. This flag is optional and will cause wsgen to generate a WSDL file and is usually
only used so that the developer can look at the WSDL before the endpoint is deploy. The protocol is optional and is used to specify
what protocol should be used in the wsdl:binding. Valid protocols include: soap1.1 and Xsoap1.2. The default is soap1.1. Xsoap1.2
is not standard and can only be used in conjunction with the -extension option.
-servicename name
Used only in conjunction with the -wsdl option. Used to specify a particular wsdl:service name to be generated in the WSDL. Exam-
ple, -servicename "{http://mynamespace/}MyService"
-portname name
Used only in conjunction with the -wsdl option. Used to specify a particular wsdl:port name to be generated in the WSDL. Example,
-portname "{http://mynamespace/}MyPort"
Example
wsgen -cp . -wsdl fromjava.server.AddNumbersImpl
This generates the portable JAX-WS artifacts that are required for Web Service deployment. It also generates the WSDL for the Web Service
with the -wsdl option.
07 Aug 2006 wsgen(1)