10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I need to replace consecutive double quotes in a csv file, the data in the file is enclosed in double quotes but there are some places where the quotes are repeating
Example is below
Incoming data is :
"Pacific Region"|"PNG"|"Jimmy""|""|
Need output as:
"Pacific... (10 Replies)
Discussion started by: abhilashnair
10 Replies
2. Shell Programming and Scripting
Hi All,
I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes.
Sample Data :
"221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 Replies
3. Shell Programming and Scripting
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Discussion started by: mathias23
5 Replies
4. Shell Programming and Scripting
Hi All,
I have been trying to replace a string using the sed command
string value contain blackslash and double quotes. I am not a expert writer of unix script but do try not to ask question. I have almost given up. Hope you all can give me some suggestion
I want to replace a place string... (6 Replies)
Discussion started by: thanush9sep
6 Replies
5. Shell Programming and Scripting
Hello,
Need a AWK command to find and replace Double Quotes in Pipe delimited files
Actully its a CSV file converted to Pipe but the double quotes still exists. So i want to Get rid of them.
Example
Input
1|2|3|sadsad|"Abc Efg 3"""|dada
Output
1|2|3|sadsad|Abc Efg 3"|dada
Thanks... (5 Replies)
Discussion started by: krux_rap
5 Replies
6. Shell Programming and Scripting
Hello to all,
I'm trying to match only fields surrounded by double quotes that have one or more commas inside.
The text is like this
"one, t2o",334,"tst,982-0",881,"kmk 9-l","kkd, 115-001, jj-3",5
The matches should be
"one, t2o"
"tst,982-0"
"kkd, 115-001, jj-3"
I'm trying with... (11 Replies)
Discussion started by: Ophiuchus
11 Replies
7. Shell Programming and Scripting
Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote.
Please see the sample file as below:
column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10... (8 Replies)
Discussion started by: dhruuv369
8 Replies
8. Shell Programming and Scripting
Hi,
I have an input file like this
$ cat infile
hi,i,"am , sam", y
hello ,good, morning
abcd, " ef, gh " ,ij
no, "good,morning", yes, "good , afternoon"
from this file I have to split the fields on basis of comma"," however, I the data present inside double qoutes should be treated as... (3 Replies)
Discussion started by: sam05121988
3 Replies
9. Shell Programming and Scripting
Hi,
I have data as
"01/22/97-"aaaaaaaaaaaaaaaaa""aaa""aabbbbbbbbcccccc""zbcd""dddddddddeeeeeeeeefffffff"
I want to remove only the Consequitive double quotes and not the one which occurs single.
My O/P must be ... (2 Replies)
Discussion started by: Bhuvaneswari
2 Replies
10. Shell Programming and Scripting
Hi,
I am trying to replace a specific column values in a csv file with double quotes.
Example:
SNO,NAME,ZIPCODE,RANK
1,Robert,74538,12
2,Sam,07564,13
3,Kim, Ed,12345,14
Desired Output:
SNO,NAME,ZIPCODE,RANK
1,Robert Ken,74538,12
2,Sam Mik,"07564",13
3,"Kim, Ed",12345,14
I... (3 Replies)
Discussion started by: techmoris
3 Replies