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

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 302984182 by RavinderSingh13 on Friday 21st of October 2016 03:58:44 PM

Old

10-21-2016

Moderator

Hello Ken6503,

Could you please try following too and let me know if this helps you.

Code:

awk '{for(i=1;i<=NF;i++){if(i==1 || i==NF){gsub(/,/,X,$i);print $i} else {print $i};}}' RS="" FS="\n"  Input_file

Output will be as follows.

Code:

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

Thanks,
R. Singh

This User Gave Thanks to RavinderSingh13 For This Post:

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

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 CENTOS

rmvq

rmvq(9F)						   Kernel Functions for Drivers 						  rmvq(9F)

NAME

       rmvq - remove a message from a queue

SYNOPSIS

       #include <sys/stream.h>

       void rmvq(queue_t *q, mblk_t *mp);

INTERFACE LEVEL

       Architecture independent level 1 (DDI/DKI).

PARAMETERS

       q	Queue containing the message to be removed.

       mp	Message to remove.

DESCRIPTION

       rmvq()  removes	a  message  from a queue. A message can be removed from anywhere on a queue. To prevent modules and drivers from having to
       deal with the internals of message linkage on a queue, either rmvq() or getq(9F) should be used to remove a message from a queue.

CONTEXT

       rmvq() can be called from user or interrupt context.

EXAMPLES

       This code fragment illustrates how one may flush one type of message from a queue. In this  case,  only	M_PROTO  T_DATA_IND  messages  are
       flushed.  For each message on the queue, if it is an M_PROTO message (line 8) of type T_DATA_IND (line 10), save a pointer to the next mes-
       sage (line 11), remove the T_DATA_IND message (line 12) and free it (line 13). Continue with the next message in the list (line 19).

	1  mblk_t *mp, *nmp;
	2  queue_t *q;
	3  union T_primitives *tp;
	4
	5   /* Insert code here to protect queue and message block */
	6   mp = q->q_first;
	7   while (mp) {
	8	 if (mp->b_datap->db_type == M_PROTO) {
	9	      tp = (union T_primitives *)mp->b_rptr;
       10	      if (tp->type == T_DATA_IND) {
       11		   nmp = mp->b_next;
       12		   rmvq(q, mp);
       13		   freemsg(mp);
       14		   mp = nmp;
       15	      } else {
       16		   mp = mp->b_next;
       17	      }
       18	 } else {
       19	      mp = mp->b_next;
       20	 }
       21   }
       22   /* End of region that must be protected */

       When using rmvq(), you must ensure that the queue and the message block is not modified by another thread at the same time. You can achieve
       this either by using STREAMS functions or by implementing your own locking.

SEE ALSO

       freemsg(9F), getq(9F), insq(9F)

       Writing Device Drivers

       STREAMS Programming Guide

WARNINGS

       Make sure that the message mp is linked onto q to avoid a possible system panic.

SunOS 5.10							    9 Jul 2001								  rmvq(9F)