Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Bring values in the second column into single line (comma sep) for uniq value in the first column
Top Forums Shell Programming and Scripting Bring values in the second column into single line (comma sep) for uniq value in the first column Post 302980362 by RavinderSingh13 on Friday 26th of August 2016 10:16:27 AM
Old 08-26-2016
Hello kchinnam,

Could you please try following. If you are not bothered about the sequence of the output(same as Input_file) then following may help.
Code:
awk '{Q=$1} ($1 in A){$1=X} {A[Q]=A[Q]?A[Q] s1 $0:$0} END{for(i in A){print A[i]}}' s1=","   Input_file

Output will be as follows.
Code:
jvm01, Web 2.0 Feature Pack Library, IBM WebSphere JAX-RS, Custom01 Shared Library
jvm02, Web 2.0 Feature Pack Library, IBM WebSphere JAX-RS
jvm03, Web 2.0 Feature Pack Library, IBM WebSphere JAX-RS, Custom03 Shared Library

NOTE: As RudiC mentioned already your Input_file is different. I had used latest Input_file in above.

Thanks,
R. Singh
Last edited by RavinderSingh13; 08-26-2016 at 11:17 AM.. Reason: Added note here.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

need to get the last word in comma sep line

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)
Discussion started by: senthilk615
9 Replies

2. Shell Programming and Scripting

Converting Column values to comma delimted single Row

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)
Discussion started by: nvuradi
5 Replies

3. Shell Programming and Scripting

Concatenating column values with unique id into single row

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)
Discussion started by: jsaravana
17 Replies

4. Shell Programming and Scripting

rearrange the column names with comma as column delimiter

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)
Discussion started by: madhav62
5 Replies

5. Shell Programming and Scripting

Multiple lines in a single column to be merged as a single line for a record

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)
Discussion started by: Bhuvaneswari
1 Replies

6. UNIX for Dummies Questions & Answers

Re: How To Use UNIQ UNIX Command On single Column

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)
Discussion started by: anudeepkumar123
2 Replies

7. Shell Programming and Scripting

splitting single column values into text and number component

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)
Discussion started by: origamisven
3 Replies

8. Shell Programming and Scripting

How to use regex on particular column (Removing comma from particular column)?

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)
Discussion started by: Prathmesh
6 Replies

9. Shell Programming and Scripting

Replacing values into a single column. sed/PERL

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)
Discussion started by: satir
7 Replies

10. Shell Programming and Scripting

HELP - uniq values per column

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 SUNOS

asmigrate

asmigrate(1m)						    Application Server Utility						     asmigrate(1m)

NAME

       asmigrate - automates migration of J2EE applications from other J2EE platforms to Sun Java System Application Server

SYNOPSIS

       asmigrate  [-h  |  --help]  [-v	|  --version]  [(-c  |--commandline)  |  (-u  --ui) ] [-q | --quiet] [-d | --debug][-s | --sourcedirectory
       source_directory] [-S | --sourceserver source_application_server] [-t |	--targetdirectory  target_directory]  [-T  |  --targetserver  tar-
       get_application_server]	[-n  |	--scan-native-apis-only  ]  [-p  | --scan-packages package_list] [-j | --java2db create-tables=true, drop-
       tables=true, db-vendor-name=dbVendorName]  [-m  |  --migrate-cmp  comment-pk-modifiers=true,  overwrite-conflicting-accessors=true]  [-f  |
       --file-filter  all-files=true,  html-files=true,  java-files=true,  jsp-files=true, xml-files=true, archive-files=true] [-a | --append-logs
       ][operands]

       Use the asmigrate utility to analyze your J2EE application and translate vendor specific settings to Sun JavaTMTM System Application Server
       specific settings making the application deployable on Sun's J2EE products.

       The following table identifies the supported J2EE product migrations:

       +--------------------------+--------------------------------+
       |  Source J2EE Platform	  |   Destination J2EE Platform    |
       +--------------------------+--------------------------------+
       |WebSphere    Application  |Sun ONE Application Server 6.5  |
       |Server 4.0		  |				   |
       |			  |				   |
       |WebLogic     Application  |				   |
       |Server 5.1		  |				   |
       +--------------------------+--------------------------------+
       |WebLogic     Application  |Sun ONE Application Server 7    |
       |Server 5.1, 6.0, 6.1	  |				   |
       |			  |				   |
       |WebSphere    Application  |				   |
       |Server 4.0		  |				   |
       |			  |				   |
       |JavaTMTM    2	Platform  |				   |
       |Enterprise Edition 1.3	  |				   |
       |			  |				   |
       |Sun   ONE    Application  |				   |
       |Server 6.x		  |				   |
       |			  |				   |
       |Sun ONE Web Server 6.0	  |				   |
       |			  |				   |
       |JBoss Application Server  |				   |
       |3.0			  |				   |
       |			  |				   |
       |Tomcat Web Server 4.1.12  |				   |
       +--------------------------+--------------------------------+
       |WebLogic     Application  |JavaTMTM 2 Platform, Enterprise |
       |Server 5.1, 6.0, 6.1	  |Edition 1.4 Application Server  |
       |			  |				   |
       |WebSphere    Application  |				   |
       |Server 4.0		  |				   |
       |			  |				   |
       |JavaTMTM   2	Platform  |				   |
       |Enterprise	 Edition  |				   |
       |1.3/1.4 		  |				   |
       |			  |				   |
       |Sun   ONE    Application  |				   |
       |Server 6.x		  |				   |
       |			  |				   |
       |Sun ONE Web Server 6.0	  |				   |
       |			  |				   |
       |JBoss Application Server  |				   |
       |3.0			  |				   |
       |			  |				   |
       |Tomcat Web Server 4.1.12  |				   |
       +--------------------------+--------------------------------+
       |WebLogic     Application  |Sun JavaTMTM System Application |
       |Server 5.1, 6.0, 6.1	  |Server Platform Edition 8	   |
       |			  |				   |
       |WebSphere    Application  |				   |
       |Server 4.0		  |				   |
       |			  |				   |
       |JavTMTMa    2	Platform  |				   |
       |Enterprise	 Edition  |				   |
       |1.3/1.4 		  |				   |
       |			  |				   |
       |Sun    ONE   Application  |				   |
       |Server 6.x		  |				   |
       |			  |				   |
       |Sun ONE Web Server 6.0	  |				   |
       |			  |				   |
       |JBoss Application Server  |				   |
       |3.0			  |				   |
       |			  |				   |
       |JBoss Application Server  |				   |
       |3.2			  |				   |
       |			  |				   |
       |Tomcat Web Server 4.1.12  |				   |
       +--------------------------+--------------------------------+

OPTIONS

       -h --help		displays the arguments for launching the MigrationTool.

       -v --version		displays the version of the MigrationTool.

       -u --ui			invokes the tool in user interface mode.

       -c --commandline 	invokes the tool in command-line mode.

       -q --quiet		launches the tool in quiet mode.

       -d --debug		launches the tool in debug mode.

       -s --sourcedirectory	identifes the directory where the source code to migrate or scan is present.

       -S --sourceserver	identifes the source application server of the applications to be migrated. Possible servers include:

				 o  wl51: WebLogic Application Server 5.1

				 o  wl60: WebLogic Application Server 6.0

				 o  wl61: WebLogic Application Server 6.1

				 o  as65: Sun ONE Application Server 6.5

				 o  as70: Sun ONE Application Server 7.0

				 o  ws40: WebSphere Application Server 4.0

				 o  ri13: JavaTMTM 2 Platform Enterprise Edition 1.3

				 o  ri14: JavaTMTM 2 Platform Enterprise Edition 1.3

				 o  s1ws: Sun ONE Web Server

				 o  jb30: JBoss Application Server 3.0

				 o  tc41: Tomcat Application Server 4.1

       -t --targetdirectory	target or output directory where the migrated application should be placed.

       -T --targetserver	target application server to which the application is to be migrated.

       -n --scan-native-apis-onlscans the source code only for the presence of application server specific proprietary APIs.

       -p --scan-packages	comma-separated list of Java packages to scan.

       -j --java2db		bypasses  the  creation of the sun-cmp-mapping.xml file. Instead, introduces the option argument into the sun-ejb-
			       jar.xml file. Option arguments are:

				 o  create-tables: if set to true (default), creates tables at deploy. If set to false tables are not created.

				 o  drop-tables: if set to true (default), tables are dropped at undeploy. If set to false tables are not dropped.

				 o  db-vendor-name: name of the database vendor for  the  application  to  be  migrated.  Supported  vendor  names
				    include: Oracle, Sybase, DB2, Generic SQL92, PointBase, MSSQL.

       -m --migrate-cmp 	migrates 1.1 compliant CMPs, if any, to 2.0. Option arguments are:

				 o  overwrite-conflicting-accessors:  if  set  to true (default), conflicting accessors are overwritten. If set to
				    false, conflicting accessors are not overwritten.

				 o  comment-pk-modifiers: if set to true (default), setters of primary key are commented. If set to false, setters
				    of primary key are not commented.

       -f --file-filter 	selects the type of files to migrate. Option arguments are:

				 o  all-files: if specified and set to true (default), migrates all types of files.

				 o  html-files: if specified and set to true (default), migrates HTML files.

				 o  java-files: if specified and set to true (default), migrates Java files.

				 o  jsp-files: if specified and set to true (default), migrates JSP type files.

				 o  archive-files: if specified and set to true (default), migrates jar/ear/war/rar file types.

       -a --append-logs 	if  specified,	appends  the  logging to the existing or previous logs without overwriting them. If not specified,
			       previous logs are overwritten.

       operands 		identifes the archive file (jar/ear/war/rar) to be migrated.

SEE ALSO

       asupgrade(1M)

J2EE 1.4 SDK							    March 2004							     asmigrate(1m)
All times are GMT -4. The time now is 03:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy