Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Add double quotes around the string

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add double quotes around the string
# 8  
Old 03-30-2009
I though it should be something like this (I know that sed is wrong):
#!/bin/bash
for ff in `find . -type f`
do
sed -e 's/table *$/\table \"*$\"/g' ff
done
#take everything after word table until the end of line and add double quotes around it.
# 9  
Old 03-30-2009
Hammer & Screwdriver ok, with sed...
Code:
> cat file6
select into table /dir1/dir2/aaa.dat
> cat file6 | sed 's/table /table "/' | sed 's/$/"/'
select into table "/dir1/dir2/aaa.dat"

or, finding the first / character
Code:
> cat file6 | sed 's/\//"\//' | sed 's/$/"/'
select into table "/dir1/dir2/aaa.dat"

# 10  
Old 03-30-2009
May be I ma doing something wrong but it is not working:
#!/bin/bash
for ff in `find . -type f`
do
cat ff|sed 's/table /table "/'|sed 's/$/"/'
done
# 11  
Old 03-30-2009
Hammer & Screwdriver spacing around | (pipes) is important
perhaps...
Code:
cat ff | sed 's/table /table "/' | sed 's/$/"/'

# 12  
Old 03-31-2009
cat $ff ...... adds " before each table (good) and ^M" after each line in the script (bad!) instead of adding only " at the end of the string table /dir1/dir2/aaa.dat. .... Very close!
# 13  
Old 03-31-2009
Hammer & Screwdriver
Did not realize more stuff at end of each line.

Code:
> cat file6                                         
select into table /dir1/dir2/aaa.dat more stuff
select into table /dir2/dir4/bbb.dat more stuff
> cat file6 | sed 's/table /table "/' | sed 's/dat/dat"/'
select into table "/dir1/dir2/aaa.dat" more stuff
select into table "/dir2/dir4/bbb.dat" more stuf

# 14  
Old 03-31-2009
Need to find the end of this particular line and insert " right before ^n: dat is not always present.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace double quotes inside the string data for all the columns

Please use code tags Hi, I have input data is below format and n of column in the multiple flat files. the string data has any double quotes(") values replaced to double double quotes for all the columns{""). Also, my input flat file each column string data has carriage of new line too.... (14 Replies)
Discussion started by: SSrini
14 Replies

2. Shell Programming and Scripting

Replace Double quotes within double quotes in a column with space while loading a CSV file

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

sed command to replace string that contain blackslash,double quotes

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

4. Shell Programming and Scripting

Adding double quotes at the end of string

My input is this: Inputfile = file.txt needs to change to, Inputfile = file.txt" I have tried using: Inputfile = `echo ${Inputfile}"' doesn't work for me. Similarly how do I change it to all double quotes: Inputfile = "file.txt" (4 Replies)
Discussion started by: bvnprasad123
4 Replies

5. Shell Programming and Scripting

Replace double quotes with a single quote within a double quoted string

Hi Froum. I have tried in vain to find a solution for this problem - I'm trying to replace any double quotes within a quoted string with a single quote, leaving everything else as is. I have the following data: Before: ... (32 Replies)
Discussion started by: pchang
32 Replies

6. Shell Programming and Scripting

How to find a string with double quotes?

I have thousands of files in a directory. I need to find/list all files that have the below matching string - RETURNCODE: "1017" Thank you! (5 Replies)
Discussion started by: esmgr
5 Replies

7. Shell Programming and Scripting

Use double quotes as part of the string in a Bash array

So I need to create an array that has " in the string of the text: string = ( "value 1" "value2" where the actual string is "value1" with the quotations included would this work? string = ( \"value1\" \"value\") and if the strings contain spaces as well: string = ("\"this... (4 Replies)
Discussion started by: os2mac
4 Replies

8. Shell Programming and Scripting

How to remove extra double quotes from string in a delimited file??

Hi Unix Gurus.. I am new to Unix. Please help me. The file I am getting is as follows: Input File "2011-07-06 03:53:23","0","I","NOT SET ",,,,"123985","SAW CUT CONCRETE SLAB 20"THICK",,"98.57","","EACH","N" "2011-07-06 03:53:23","0","I","NOT SET ",,,,"204312","ARMAFLEX-1 3/8 X... (2 Replies)
Discussion started by: BICC
2 Replies

9. UNIX for Dummies Questions & Answers

how to use grep: finding a string with double quotes and multiple digits

I have a file with a lot of lines (a lot!) that contain 10 digits between double quotes. ie "1726937489". The digits are random throughout, but always contain ten digits. I can not for the life of me, (via scouring the internet and grep how-to manuals) figure out how to find this when I search.... (3 Replies)
Discussion started by: titusbass
3 Replies

10. Shell Programming and Scripting

how to find the count of commas in a string excluding the ones in double quotes

Hi, my requirement is to find the count of commas in a string excluding the ones in double quotes. For example: If the input string is abc,xyz.com,lmhgdf,"abc, 401 street","tty,stt",45,23,45 The output should be 7 (7 Replies)
Discussion started by: amitshete
7 Replies
Login or Register to Ask a Question