How to remove comma from first and last line? Post: 302984174

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting How to remove comma from first and last line? Post 302984174 by ken6503 on Friday 21st of October 2016 02:57:09 PM

Old

10-21-2016

Registered User

How to remove comma from first and last line?

Hi Gurus,

I need to remove comma from first and last line. I tried below code, but no luck. It only remove first line.
Gurus, please help.

Code:

 
 awk -F"," '{if(NR==1||NR==$NR) print $1; else print $0}' TEST

sampe file:

Code:

 
 ABC HEADER TOTAL RECORDS ARE 2.00,,,,
C,300,ABC,BC,
C,400,ABC,TO,
ABC TRAILER. ACCOUNT SUM IS 3000.00,,,,

expect:

Code:

 
 ABC HEADER TOTAL RECORDS ARE 2.00
C,300,ABC,BC,
C,400,ABC,TO,
ABC TRAILER. ACCOUNT SUM IS 3000.00

ken6503

View Public Profile for ken6503

Find all posts by ken6503

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

remove unnecessary comma from file

HI all, I have a file with following data - test1 "ABC,D",1234,"XYZ,QWER",1234 "SZXA",9870,"ASD,QWERT",234 "XZ,SD",9478,"ADCS,AXZ",876 "WESR",8764,"AQZXAS",9888 "WESR",9898,"WESDRTSAW",3323 I need to get rid of unnecessary commas in fields having double quotes. Ouput - ...

2. UNIX for Dummies Questions & Answers

How to remove comma from the last line of the file

Hi, I have a file which has records which end with a comma. for example: My file looks like 1234, 5678, 3455, 3566, 4444, 9999, I need to remove comma for the last line in the file so that my file should look like: 1234, 5678, 3455,

3. Shell Programming and Scripting

Awk: Remove comma at the end of the string

Hi i had String like UID: ABC345QWE678GFK345SA90, LENGTH 32 when I used awk ' FS, {print $1}' prints ABC345QWE678GFK345SA90, how can i getrid of that coma at the end of the string. Thanks in advance..

4. Shell Programming and Scripting

Remove the tail comma

Hi, I have one file with the following details, file1.txt ====== The following are the accounts which are having the balance 22,22,22,10,12,00000013, Here I want to delete the tail comma. Can anybody help me out... Thanks in advance..!!

5. Shell Programming and Scripting

How to grep after the first comma till the next comma in a line

Hi Can any one pls tell me how to grep this line POPULATION,69691,20120509 I want the number 69691 from the above line. How to grep from the first comma till the next comma. Thank You.:confused:

6. UNIX for Dummies Questions & Answers

Remove First Char from Line in File Only if it's a comma

I have a file, I need to remove the first character of each line, but only if it's a comma. I don't want to delete any other commas in each line. Trying cat or sed but I really don't know them very well, would love some help. This removes the first comma, but it removes the first comma no...

7. Shell Programming and Scripting

How to Remove comma as last character in end of last line of file?

how to Remove comma as last charector in end of last line of file: example: input file --------------- aaaaaa, bbbbbb, cccc, 12345, ____________ output file : ----------- aaaaaa, bbbbbb,

8. Shell Programming and Scripting

How to remove last comma?

Hi Gurus, I have file like below: a b c d .. I want to get 'a','b','c', 'd' I try to use below command to get it, but I got one extra comma sed "s/.*/'&'/" code_LIST.txt |tr -s '\n' "," I got below result: 'a','b','c','d', there is one extra comma at end of the line. How can I...

9. Shell Programming and Scripting

How can we remove comma from end of each line ?

Hi, How can we remove the comma from the end of each line. I have a csv file in below format. file.csv Name,age,gender,location, Joel,18,M,Newyork, Monoj,21,M,Japan, Litu,23,M,turki, Expected o/p file1.csv Name,age,gender,location

10. Shell Programming and Scripting

How to remove comma?

hi all, in the 3rd field i am having comma. can anyone tell me how to remove the comma in the 3rd field and 4th field. |1.77|0.1|1,335.20|3,513.30|190|7.00 |4.40 |2.50 |1|1|5|5|Section903-Liquor|StLouis|0||||||||||| 40997|9999999|9999999|195186280|0102796|36949|00083089660358|2016|MAY ...

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)