01-22-2010
Thanks Scott it work perfectly fine
sed "s/,/\\\,/g;s/|/,/g" testcommafile.txt > newfile
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
dear, I would like to rename files in a dir to another format, so I write a bash shell script to handle it. But my problem now is how to handle files having special characters like spaces, (, ):
"a b c (d).doc"
It seems that I need to escape those characters before applying the "mv" command.... (1 Reply)
Discussion started by: lau0001
1 Replies
2. Shell Programming and Scripting
Hi,
I am trying to truncate word after comma in a file ONLY if there are already 2 words BEFORE comma. If there is one word or 3 or more words BEFORE comma, then I have to leave the data AS IS. See below for example.
Input File :
John Smith, Manager
Smith, John Frank
J F K... (2 Replies)
Discussion started by: msalam65
2 Replies
3. Shell Programming and Scripting
Hi,
I have a file xy.csv with the following data separated by pipe (|):
BC-NACO|12>ISA43<TEST|
A & A INC|FAMOUS'S AL|
i need to escape the xml characters as below
BC-NACO|12>ISA43<TEST|
A & A INC|FAMOUS'S AL|
Please advise (5 Replies)
Discussion started by: prasannarajesh
5 Replies
4. 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
5. Shell Programming and Scripting
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies
6. Shell Programming and Scripting
I,
I have a file and i need to replace comma and blank space with comma and 0.
cat file.txt
a,5
b,1
c,
d,
e,4
I need the output as
cat file.txt
a,5
b,1
c,0
d,0 (4 Replies)
Discussion started by: jaituteja
4 Replies
7. Shell Programming and Scripting
Hi,,
I have the line below in a file:
$!VarSet |LFDSFN1| = '"E:\APC\Trials\20140705_427_Prototype Trial\Data\T4_20140705_Trial_Cycle_Data_13_T_Norm.txt" "VERSION=100 FILEEXT=\"*.txt\" FILEDESC=\"General Text\" "+""+"TITLE{SEARCH=NONE NAME=\"New Dataset\" LINE=1I want to write a script to change... (2 Replies)
Discussion started by: carlr
2 Replies
8. Shell Programming and Scripting
Hello ppl
I have a requirement to split (cut in unix) a file (A.txt) which is a pipe delimited file into A1.txt and A2.txt
Now I have to join (paste in unix) this A2.txt with external file A3.txt to form
output file A4.txt which should be CSV (comma separated file) so that third party can... (25 Replies)
Discussion started by: etldev
25 Replies
9. Shell Programming and Scripting
I have a comma delimited file of major codes and descriptions. I want to replace all occurrences of spaces with underscores up to the first comma (only in the first field), but not replace spaces following the comma. For instance I have the following snippet of the file:
EK ED,Elementary and... (7 Replies)
Discussion started by: tdouty
7 Replies
10. Shell Programming and Scripting
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Discussion started by: as7951
3 Replies
LEARN ABOUT CENTOS
vorbiscomment
VORBISCOMMENT(1) Ogg Vorbis Tools VORBISCOMMENT(1)
NAME
vorbiscomment - List or edit comments in Ogg Vorbis files
SYNOPSIS
vorbiscomment [-l] [-R] [-e] file.ogg
vorbiscomment -a [ -c commentfile | -t "name=value" ] [-q] [-R] [-e] in.ogg [out.ogg]
vorbiscomment -w [ -c commentfile | -t "name=value" ] [-q] [-R] [-e] in.ogg [out.ogg]
DESCRIPTION
vorbiscomment Reads, modifies, and appends Ogg Vorbis audio file metadata tags.
OPTIONS
-a, --append
Append comments.
-c file, --commentfile file
Take comments from a file. The file is the same format as is output by the -l option or given to the -t option: one element per line
in 'tag=value' format. If the file is /dev/null and -w was passed, the existing comments will be removed.
-h, --help
Show command help.
-l, --list
List the comments in the Ogg Vorbis file.
-t 'name=value', --tag 'name=value'
Specify a new tag on the command line. Each tag is given as a single string. The part before the '=' is treated as the tag name and
the part after as the value.
-w, --write
Replace comments with the new set given either on the command line with -t or from a file with -c. If neither -c nor -t is given,
the new set will be read from the standard input.
-R, --raw
Read and write comments in UTF-8, rather than converting to the user's character set.
-e, --escapes
Quote/unquote newlines and backslashes in the comments. This ensures every comment is exactly one line in the output (or input),
allowing to filter and round-trip them. Without it, you can only write multi-line comments by using -t and you can't reliably dis-
tinguish them from multiple one-line comments.
Supported escapes are c-style "
", "
", "\" and "