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
# 1  
Old 03-30-2009
Add double quotes around the string
I have a line in multiple scripts:select into table /dir1/dir2/file.dat
dir1 and dir2 are the same but file.dat is different from script to script.
I need to include /dir1/dir2/file.dat into double quotes in each file of my directory:select into table "/dir1/dir2/file.dat"
# 2  
Old 03-30-2009
Hammer & Screwdriver Is this what you are trying to do?
Code:
> val12=/dir1/dir2/file.dat
> echo 'select into table "'$val12'"'
select into table "/dir1/dir2/file.dat"

# 3  
Old 03-30-2009
Yes. Any ideas?
# 4  
Old 03-30-2009
Hammer & Screwdriver
Not exactly sure what you are trying to do.
My previous post gave an approach, but since you have not supplied specific scripts and files, it is impossible to write more.

If you supply more info, then more details can be provided.

Code:
> val12=/dir1/dir2/file.dat
> echo 'select into table "'$val12'"'
select into table "/dir1/dir2/file.dat"

# 5  
Old 03-30-2009
Sorry. For ex., there are two files file1.prg and file2.prg in Unix driectory. 1st file has string :
select into table /dir1/dir2/aaa.dat.
2d file has a string :
select into table /dir1/dir2/bbb.dat.
I need to insert double quotes around /dir1/dir2/*.dat in each file.
So, it will look like :
select into table "/dir1/dir2/aaa.dat" in file1.prg
and
select into table "/dir1/dir2/bbb.dat" in file2.prg.
# 6  
Old 03-30-2009
Looks like he needs to correct the syntax of a line contained in multiple scripts. Not stated whether each script could contain more than one select line or whether the select line is left justified.

Before
select into table /dir1/dir2/file.dat
After
select into table "/dir1/dir2/file.dat"

Also the "file.dat" part varies from script to script.

Anybody good with "sed" ?
# 7  
Old 03-30-2009
Hammer & Screwdriver here it is using awk
Code:
> cat file6
select into table /dir1/dir2/aaa.dat

Code:
> cat file6 | awk '{print $1" "$2" "$3" \""$4"\""}'
select into table "/dir1/dir2/aaa.dat"

or, eliminating a useless 'cat'
Code:
> awk '{print $1" "$2" "$3" \""$4"\""}' <file6
select into table "/dir1/dir2/aaa.dat"

either can have
Code:
>file6x

appended to the command to write-out a new file.
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