10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
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
5. UNIX for Dummies Questions & Answers
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
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. UNIX for Dummies Questions & Answers
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
10. UNIX for Advanced & Expert Users
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