Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to remove comma from first and last line?
Top Forums Shell Programming and Scripting How to remove comma from first and last line? Post 302984178 by RudiC on Friday 21st of October 2016 03:42:45 PM
Old 10-21-2016
awk doesn't know about the last line when it works on the last line, only afterwards. So it's not THAT easy in awk:
Code:
awk 'LAST {print LAST}; NR==1 {gsub (/,/,_)}; {LAST = $0} END {gsub (/,/, _, LAST); print LAST}' file
 ABC HEADER TOTAL RECORDS ARE 2.00
C,300,ABC,BC,
C,400,ABC,TO,
ABC TRAILER. ACCOUNT SUM IS 3000.00

This User Gave Thanks to RudiC For This Post:
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 - ... (1 Reply)
Discussion started by: sumeet
1 Replies

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, (5 Replies)
Discussion started by: sandeep_1105
5 Replies

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.. (14 Replies)
Discussion started by: Reddy482
14 Replies

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..!! (3 Replies)
Discussion started by: Kattoor
3 Replies

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: (8 Replies)
Discussion started by: rxg
8 Replies

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... (6 Replies)
Discussion started by: Cynthia
6 Replies

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, (6 Replies)
Discussion started by: RahulJoshi
6 Replies

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... (10 Replies)
Discussion started by: ken6503
10 Replies

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 (4 Replies)
Discussion started by: Litu19
4 Replies

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 ... (2 Replies)
Discussion started by: arun888
2 Replies

LEARN ABOUT CENTOS

lgroupmod

lgroupmod(1)						      General Commands Manual						      lgroupmod(1)

NAME

       lgroupmod - Modify an user group

SYNOPSIS

       lgroupmod [OPTION]... group

DESCRIPTION

       Modifies the user group with name group.

OPTIONS

       -A, --admin-add=list
	      Add users in comma-separated list among group's administrators.

       -a, --admin-remove=list
	      Remove  users  in comma-separated list from group's administrators.  Removing users that are not currently among group's administra-
	      tors silently succeeds.

       -g, --gid=gid
	      Change group's group ID to gid.

       -i, --interactive
	      Ask all questions when connecting to the user database, even if default answers are set up in libuser configuration.

       -L, --lock
	      Lock group.  This prevents users from using the group password with newgrp(1) to become a member of group.

       -M, --member-add=list
	      Add users in comma-separated list among group's members.

       -m, --member-remove=list
	      Remove users in comma-separated list from group's members.  Removing users that are not currently  among	group's  members  silently
	      succeeds.

       -n, --name=name
	      Rename group to name.

       -P, --plainpassword=password
	      Set group's password to password.  Note that the password can be viewed while running lgroupmod using tools such as ps(1).

       -p, --password=encrypted
	      Set  group's  password  to the password represented by the hash encrypted.  Note that the hash can be viewed while running lgroupmod
	      using tools such as ps(1).

       -U, --unlock
	      Unlock group.

EXIT STATUS

       The exit status is 0 on success, nonzero on error.

libuser 							    Jan 11 2005 						      lgroupmod(1)
All times are GMT -4. The time now is 12:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy