9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies
2. Shell Programming and Scripting
From:
1,2,3,4,5,This is a test
6,7,8,9,0,"This, is a test"
1,9,2,8,3,"This is a ""test"""
4,7,3,1,8,""""
To:
1,2,3,4,5,This is a test
6,7,8,9,0,"This; is a test"
1,9,2,8,3,"This is a ''test''"
4,7,3,1,8,"''"Is there an easy syntax I'm overlooking? There will always be an odd number... (5 Replies)
Discussion started by: Michael Stora
5 Replies
3. Shell Programming and Scripting
Hi All ,
We have source data file as csv file and since data could contain commas ,each attribute is quoted into double quotes.However problem is that some of the attributa data also contain double quotes which is converted to double double quote while creating csv file
XLs data :
... (2 Replies)
Discussion started by: Shalini Badal
2 Replies
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
Can somebody supply me with a simple way to get a value between
two double quotes?
Example:
input = ADR base is "/u01/app/oracle"
output = /u01/app/oracle
Thanks to all who answer (4 Replies)
Discussion started by: BeefStu
4 Replies
6. Shell Programming and Scripting
I'm trying to extract a column from a csv file with either cut or awk but some of the fields contain comma with them:
"Field1","Field2, additional info","Field3",...,"Field17",...
If I want to extract column 3 and use comma as the delimiter, I'll actually get the additional info bit but not... (4 Replies)
Discussion started by: ivpz
4 Replies
7. Shell Programming and Scripting
Could you please help in unix scripting for below scenario...
In my input file, there might be a chance of having a string ( Ex:"99999") after 5th double quote for each record. I need to replace it with a space.
Ex : Input :
"abcdef","12345","99999","0986"... (3 Replies)
Discussion started by: vsairam
3 Replies
8. Shell Programming and Scripting
Hi,
I've been trying to write a regex to use in egrep (in a shell script) that'll fetch the names of all the files that match a particular pattern. I expect to match the following line in a file:
Name = "abc"
The regex I'm using to match the same is:
egrep -l '(^) *= *" ** *"$' /PATH_TO_SEARCH... (6 Replies)
Discussion started by: NanJ
6 Replies
9. Shell Programming and Scripting
hey all,
i made a simple .sh like this:
echo "<style media="screen" type="text/css">@import url("main.css");</style>"
but the output is:
<style media=screen type=text/css>@import url(main.css);</style>
i want to keep double-quotes, can anyone help me?
thanks (3 Replies)
Discussion started by: indraf
3 Replies