10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
2. UNIX for Dummies Questions & Answers
I have several lines in a file that I want to replace a space with a tab.
For example:
111047 Julie Jones email@email.com
111047 Julie Jones email@email.com
I want to replace the space after the word "jones" with a tab.
How do I achieve that in Vi?
Please assist.
Thanks! (5 Replies)
Discussion started by: onlinelearner02
5 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I have this:
begin data;
dimensions nind=168 nloci=6;
info
BDT001.4 ( 1 , 1 ) ( 1 , 12 )
BDT003.4 ( 1 , 1 ) ( 12 , 12 )
BDT007.4 ( 1 , 1 ) ( 12 , 12 )
BDT009.4 ( 1 , 32 ) ( 12 , 22 )
etc, etc
And need this:
begin data;
dimensions nind=168 nloci=6;
info
... (2 Replies)
Discussion started by: MDeBiasse
2 Replies
4. Shell Programming and Scripting
Hi ,
I have a file with 5 colums each are sererated by tab. I am reading each line and adding extra two columns , the value depends on 5th column..
Now am trying to store each and every record in another file..
using the command echo $line $6thcol $7th col
$line - readin the each... (2 Replies)
Discussion started by: arukuku
2 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have the following code:
LIST=`ls | grep '.sql$'`
echo $LIST
The above code will give me something like..
file1.sh file2.sh file3.sh file4.sh file5.sh
I want to display the values into rows using echo like...
file1.sh
file2.sh (5 Replies)
Discussion started by: adshocker
5 Replies
6. Shell Programming and Scripting
trying to insert a LF and 2 TABs for this:
sed 's/<td><\/td>/<td>\n\t\t<\/td>/' infile.
but, I'm not getting the syntax for inserting the LF and TABs correct (1 Reply)
Discussion started by: dba_frog
1 Replies
7. Shell Programming and Scripting
Hi All,
I am using Unix ksh script.
I need to insert values to a table using the o/p from a slelect statement.
Can anybody Help!
My script looks like tihs.
---`sqlplus -s username/password@SID << EOF
set heading off
set feedback off
set pages 0
insert into ${TB_NAME}_D... (2 Replies)
Discussion started by: nkosaraju
2 Replies
8. Shell Programming and Scripting
Hi,
I'm using the following to insert lines into file:
sed ${rowNr}i'\
first row\
second row\
third row\
' file.txt
How can I add tab in front of each added line? "\t" or actual TAB does not seem to work?
Thanks! (2 Replies)
Discussion started by: Juha
2 Replies
9. UNIX for Dummies Questions & Answers
I have input like:
1234567890
cut -c1-3,6-7,9-10 input > output
Now I got 1236790.
I want to insert space between each cut. So the output like:
123 67 90
Can anybody help?
Thanks. (7 Replies)
Discussion started by: sslr
7 Replies
10. Shell Programming and Scripting
I've tried this:
echo "${bold}User${norm} : u"\t"${bold}All Users ${norm} : a\t"
and i got this output:
Specific User : u\tAll User: a\t (14 Replies)
Discussion started by: laila63
14 Replies