02-09-2010
10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. Shell Programming and Scripting
Hello friends,
I have a file which consists of many rows, I use a couple of commands to convert it so i can use in a database query for filtering. I need the first columns (msisdns) in a row, seperated with commas,
9855162267,4,5,2010-11-03 17:02:07.627
9594567938f,5,5,2010-11-02... (9 Replies)
Discussion started by: EAGL€
9 Replies
5. Shell Programming and Scripting
Hi Experts ,
My requirement is like this ..
I have source comming as 4,234.55
I need and out put = 4234.55
I need to write a sed command ..
I have already used sed command for multiple conditions in a file for replacing comma , double quotes , brackets , retain negative values..... (3 Replies)
Discussion started by: bshivali
3 Replies
6. 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
7. 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
8. 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
9. Shell Programming and Scripting
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.
awk -F"," '{if(NR==1||NR==$NR) print $1; else print $0}' TEST
sampe file:
ABC HEADER TOTAL RECORDS ARE 2.00,,,,... (13 Replies)
Discussion started by: ken6503
13 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have following input file:
niki niki
niki1 niki
niki2 niki,niki2
niki3 niki,niki3,niki
niki4 niki4,blabla
niki5 jkjkl
niki6 niki60,niki6
I would like to delete lines with identical matches completely and remove the selfmatches in the other lines.
... (2 Replies)
Discussion started by: niki0211
2 Replies
LEARN ABOUT LINUX
motd.tail
MOTD.TAIL(5) Debian Administrator's Manual MOTD.TAIL(5)
NAME
motd.tail - Template for building the system message of the day
DESCRIPTION
On Debian systems, the system message of the day is rebuilt at each startup, in order to display an accurate information. /etc/motd.tail is
the file to edit permanent changes to the message of the day.
OVERVIEW
The initiation script /etc/init.d/bootmisc.sh prepends a line containing information about the system to /etc/motd.tail and stores the
resulting file in /var/run/motd. /etc/motd is a symbolic link to /var/run/motd. This is done to prevent changes to /etc as the system can
not assume /etc to be writable.
Changes to /etc/motd effectively end up in a file under /var/run which will be regenerated upon reboot.
A symbolic link to a different file, such as /etc/motd.static disables this behaviour.
FILES
/etc/init.d/bootmisc.sh
The initiation script which builds /var/run/motd
/etc/motd
Symbolic link to the system message of the day at /var/run/motd
/etc/motd.tail
Template for building the system message of the day
/var/run/motd
System message of the day file rebuilt at each computer start
SEE ALSO
login(1), issue(5), motd(5).
Debian 2007-04-28 MOTD.TAIL(5)