10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi ,
I'm new to Unix shell scripting.
I need help to insert read csv which has two columns -emp no and logged date.
csv file is a large file so i want to keep the insertion query in a separate .sql file.
csv file looks this:
empno | loggeddate
___________________
5666 ,... (5 Replies)
Discussion started by: preema
5 Replies
2. Shell Programming and Scripting
Hi,
I have a requirement where I have an excel sheet with the below values
COL1 COL2 COL3
Germany URGENT NORMAL
I want to cut the values of this excel in such a way that I get the values and pass it to an insert statement
update tbfin set... (2 Replies)
Discussion started by: venkidhadha
2 Replies
3. UNIX for Dummies Questions & Answers
I have file input.txt:
>TX1-1 Freq 55
cattctgatgaatatttgtcctttagttgttatttgt
>TX1-2 Freq 19
cattctgatgaatatttgtcctttagttgttatttgt
>TX1-3 Freq 17
cattctgatgaatatttgtcctttagttgttatttgt
>TX1-4 Freq 6
cattctgatgaatatttgtcctttagttgttatttgt
>TX1-5 Freq 6
cattctgatgaatatttgtcctttagttgttatttgt
... (5 Replies)
Discussion started by: Xterra
5 Replies
4. Shell Programming and Scripting
hi all,
i have one shell script like this
#!/bin/bash -xv
ENV_NAME=`cat $IB_HOME_DIR/cfg/ibProfile.sh | grep "RDM_CONN" | cut -f 2 -d "@"`
CURRENT_DIR=`pwd`;
string=$IB_HOME_DIR
string1="$string/FRGFOLDER/input"
#sed "s/string3/$string1" frg_event_src.sql > modifiedinsert.sql
sqlplus... (2 Replies)
Discussion started by: ramsavi
2 Replies
5. Shell Programming and Scripting
Hi Forum members,
I want to insert the filename at the top of file (i.e, first row only)
My file name is like asdf_432
And I want to insert this filename in first row as filename is asdf with serial no. 432
Thanks in advance. :) (4 Replies)
Discussion started by: CAch
4 Replies
6. Shell Programming and Scripting
Hi,
input file
CCCC 1204 215764.85 9405410.40 1189
DDDD 4498 1503 4617 1507 4723 1517 4829 1528 4996 1540
DDDD 5199 1556 5278 1567 5529 1603 5674 1614 6076 1915
DDDD 6605 2371 7004 2779
CCCC ... (4 Replies)
Discussion started by: Indra2011
4 Replies
7. Shell Programming and Scripting
In my script I am using sed to insert a line.
Suppose I have a variable called ck_size=5 and a temporary file called tmp
I want to add a certain line in the tmp file .Please see the below command
sed -i '2a\maitee is $ck_size' /dun/homes/lrsprod/tmp
I want in 2 line of tmp file... (7 Replies)
Discussion started by: maitree
7 Replies
8. Shell Programming and Scripting
Greetings, people of UNIX/Linux forums.
I am having a problem with a script, where I am trying to create a new variable. The value of this variable would be dependent on the value in a couple other previous variables (all variables are 2-digit integers). Here is my code:
#set the stations... (3 Replies)
Discussion started by: TheSMan5
3 Replies
9. Shell Programming and Scripting
how to assign values in this date format
a=`date +"%H%M%S"`
how to give value of H=22,here in this format so that i can grep 22nd hour.Below is the script
--------------------------------------------------------------------------
a=`date +"%H%M%S"`
for i in *.log
do
cat $i | grep $a... (3 Replies)
Discussion started by: ali560045
3 Replies
10. Shell Programming and Scripting
Guys,
I want to insert some values from a log file into a temporary table. the values in the log file looks like this
SV_NAME CC_NAME CP_DISP_RUN_STATE
------- ------------------- -----------------
sble01 ALLTEL WorkMon24Hrs Running
I want to enter the... (2 Replies)
Discussion started by: ragha81
2 Replies