Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: group by for lines
Top Forums Shell Programming and Scripting group by for lines Post 75704 by hellsd on Tuesday 21st of June 2005 01:44:52 PM
Old 06-21-2005
group by for lines
I post my question here also because i have a difficult script to create that do the following:

The examples i got dont support it.
Lets say the input file is:
ABC^1^~^data^x
ABC^2^~^data^x
ABC^3^~^data^x
DEF^4^~^data^y
DEF^4^~^data^z
DEF^5^~^data^y
DEF^5^~^data^z
DEF^6^~^data^z
DEF^6^~^data^y
XYZ^7^~^data^t

Now I would like to group couple of fields(field 2 and field 5) and concatenate them with comma according to my key which is the first field.
My output should be:

ABC^1,2,3^~^data^x
DEF^4,5,6^~^data^y,z
XYZ^7^~^data^t

Notice that I would like to print all the line's fields.

Is it possible?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to group lines into batches

Hi all I need to group all the lines that start with 2. For every 3 lines (that start with 2) i need to group them in one group and add 1 for each group. I need your help to batch the files content.The file look like this: 040171011140820070000000009650244002933170003000000075272... (2 Replies)
Discussion started by: ashikin_8119
2 Replies

2. Shell Programming and Scripting

Get the total of a field in all the lines of a group

Hi I have a Fixed format data file where I need to to get the total of the field at certain position in a file for a group of lines. In this data file I need the total of all the field ats position 30:39 for each line starting with 6 and for each group startign with 5. Which means for... (27 Replies)
Discussion started by: appsguy616
27 Replies

3. UNIX for Dummies Questions & Answers

sort group of n lines base on pattern in first line

I have record having 10 fields and each field being printed on a new line, first line cotains name of exchange, 2nd line stock name, third line stock price, etc etc... now i want to retrieve data only for a particular exchanged and that too only 2nd and 3rd row info... NSE RNRL 70 12 1... (1 Reply)
Discussion started by: manishma71
1 Replies

4. AIX

Delete group of lines from file

I have a rather large file that needs lines deleted periodically. How may I accomplish this task? Should I run into an error message "not enough disk space" AIX 5.3 Thanks (2 Replies)
Discussion started by: tfort73
2 Replies

5. UNIX for Advanced & Expert Users

Merge a group of lines into single line

Hi Everybody, Below are the contents of the a text file .., SN = 8 MSI = 405027002277133 IKVALUE = DE6AA6A11D42B69DF6398D44B17BC6F2 K4SNO = 2 CARDTYPE = SIM ALG = COMP128_3 SN = 8 MSI = 405027002546734 IKVALUE = 1D9F8BAA73973D8FBF8CBFB01436D822 K4SNO = 2 CARDTYPE = SIM ALG =... (8 Replies)
Discussion started by: prasanth_babu
8 Replies

6. Shell Programming and Scripting

need to delete all lines from a group of files except the 1st 2 lines

Hello, I have a group of text files with many lines in each file. I need to delete all the lines in each and only leave 2 lines in each file. (3 Replies)
Discussion started by: script_op2a
3 Replies

7. Shell Programming and Scripting

Print lines containing same values in a group

Hi, I have a table like this: Name A1 A2 A3 B1 B2 B3 111 abc abc abc cbc cbc cbc 222 acv acv n_n bbc bbc bbc 333 bvv bvv bvv cBx ccx ccx 444 ttk ttk ttk kke kke kke 555 mcr mcr mcr mcr mcr mcr The 1st column is just names... (3 Replies)
Discussion started by: polsum
3 Replies

8. Shell Programming and Scripting

Deleting lines based on a condition for a group of files

hi i have a set of similar files. i want to delete lines until certain pattern appears in those files. for a single file the following command can be used but i want to do it for all the files at a time since the number is in thousands. awk '/PATTERN/{i++}i' file (6 Replies)
Discussion started by: anurupa777
6 Replies

9. Shell Programming and Scripting

Summing columns over group of lines

I have an input file that looks like: ID1 V1 ID2 V2 P1 P2 P3 P4 ..... n no. of columns 1 1 1 1 1.0000 1.0000 1.0000 1.0000 1 1 1 2 0.9999 0.8888 0.7777 0.6666 1 2 1 1 0.8888 0.7777 0.6666 0.5555 1 2 1 2 0.7777 0.6666 0.5555 0.4444 2 1 1 1 0.6666 0.5555 0.4444 0.3333 2 1 1 2 0.5555 0.4444... (4 Replies)
Discussion started by: sdp
4 Replies

10. Shell Programming and Scripting

Group Multiple Lines on SINGLE line matching pattern

Hi Guys, I am trying to format my csv file. When I spool the file using sqlplus the single row output is wrapped on three lines. Somehow I managed to format that file and finally i am trying to make the multiple line on single line. The below command is working fine but I need to pass the... (3 Replies)
Discussion started by: RJSKR28
3 Replies

LEARN ABOUT OSF1

tokens

TOKENS(1)						       AFS Command Reference							 TOKENS(1)

NAME

       tokens, tokens.krb - Displays the issuer's tokens

SYNOPSIS

       tokens [-help]

       tokens [-h]

       tokens.krb [-help]

       tokens.krb [-h]

DESCRIPTION

       The tokens command displays all tokens (tickets) cached on the local machine for the issuer. AFS server processes require that their
       clients present a token as evidence that they have authenticated in the server's local cell.

       The (mostly obsolete) tokens.krb command is the same as tokens except that it also displays the user's Kerberos v4 ticket cache.

OPTIONS

       -help
	   Prints the online help for this command. All other valid options are ignored.

OUTPUT

       The output lists one token for each cell in which the user is authenticated. The output indicates the

       o User's AFS UID, if it is available for display.

       o Server for which the token is valid (normally, afs).  This includes a cell specification.

       o Day and time the token expires.

       The output of the Kerberos version of this command, tokens.krb, also reports the following about the Kerberos ticket-granting ticket: the
       ticket owner, which Kerberos ticket-granting service that issued the ticket (for example, "krbtgt.ABC.COM"), and ticket's expiration date.

       The string "--End of list--" appears at the end of the output. If the user is not authenticated in any cell, this line is all that appears.

EXAMPLES

       The following example shows the output when the issuer is not authenticated in any cell.

	  % tokens
	  Tokens held by the Cache Manager:

	     --End of list--

       The following example shows the output when the issuer is authenticated in ABC Corporation cell, where he or she has AFS UID 1000.

	  % tokens
	  Tokens held by the Cache Manager:

	  User's (AFS ID 1000) tokens for afs@abc.com [Expires Jan 2 10:00]
	     --End of list--

       The following example shows the output when the issuer is authenticated in the ABC Corporation cell, the State University cell, and the XYZ
       Company cell. The user has different AFS UIDs in the three cells. Tokens for last cell are expired:

	  % tokens
	  Tokens held by the Cache Manager:

	  User's (AFS ID 1000) tokens for afs@abc.com [Expires Jan 3 10:00]
	  User's (AFS ID 4286) tokens for afs@stateu.edu [Expires Jan 3 1:34]
	  User's (AFS ID 22) tokens for afs@xyz.com [>>Expired<]
	     --End of list--

       The following example shows the output when the issuer uses the tokens.krb version of the command after authenticating in the ABC
       Corporation cell using the klog.krb command.

	  % tokens.krb
	  Tokens held by the Cache Manager:

	  User's (AFS ID 1000) tokens for afs@abc.com [Expires Jan 31 00:09]
	  User smiths tokens for krbtgt.ABC.COM@abc.com [Expires Jan 31 00:09]
	     --End of list--

PRIVILEGE REQUIRED

       None

SEE ALSO

       klog(1), unlog(1)

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								 TOKENS(1)
All times are GMT -4. The time now is 08:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy