Search Results

I am using sunSolaris.... there no lftp :(

Hi Zaxxon,

We do not have "expect" utility installed on our system... is there any other way?

Hi team,

I know if we need to transfer the files between between 2 servser, we use SFTP through key setup between 2 server.

currently There are some problems and we are not able to setup keys...

awk '/CACCIA/ || /idlck/ {print "OK"} ' input_file

Why do not you use "sleep" function.


dt=date '+%H:%M:%S'

while [ $dt = {your condition} ]
do
sleep 5
dt=date '+%H:%M:%S'
done

Hi Sudha,

But how can i make the entire line 80 characters by replacing NULl wityh space?
It is someing like left padding, right padding

How to replace null with space?

I want to make each line with 80 characters. If any line contains only 5 characters and remaining is null, then i want to make it as 80 characrets where 5 is...

Hi All,

I have found some idea to handle this situation.

Actually, each lines contains only 80 characters. But as per specification document, 540 characters are of HEADER and then 540...

Hi All,

I need your help to solve problem using either PERL script or SHELL script.

We are receving a file, in which one record is coming in multiple rows. The main problem is, we are not...

Hi All,
To transfer the files, from one server to another through SFTP, i am using below code in my script.

cur_dt=$1
echo "cd /inbox/" >> SFTP.txt # folder of traget server
echo "mput...

Sorry, initially i forgot to give data length of each column

COL1 VARCHAR2(20)
COL2 VARCHAR2(1)
COL3 VARCHAR2(1)

Hi All,

I have created a script which generates FIXED-WIDTH file by executing Oracle query.


SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ


It generates...

The problem is it is not producing any error message.

Hi All,

I am generating a ~ delimited file from oracle table and then transfer it to another server through scp.


if [ -f $COM_DIR/ABC.txt ]
then
scp $COM_DIR/ABC.txt...

Hi All,

I have a comma seperated delimited file with 10 columns. I need to convert it into TAB seperated delimited file.

awk -F"," '{print...

Give the sample data....

Hi Reva,

#!/bin/ksh
let first_year=`head -1 a.dat | awk '{print $2}'`
cat a.dat | while read abc
do
f_str=`echo $abc | awk '{print $1, $2, $3}'`
b_str=`echo $abc | awk '{print...

Hi All,

I have a data file in UNIX which i am trying to load into Oracle table using Oracle SQL Loader.

The problem is, one of the filed contains special character (ex: Square). And due to...

No tell me one thing... from where u will get list of user? Is it in a file or you need to pass dynamically each time...

For each use, do u need to create seperate file like above. If yes, what...

pass the value as input parameter in shell script.

$ ./a.sh onida /dir/onida /tmp/onida_files

#!/bin/sh

CUST=$1
DIR=$2
NULIST=$3
name=philps_123

echo "$CUST"
echo $DIR
echo $NULIST...

. script.sh

Jus give space between dot and script name

Please refere the link [/URL]

---------- Post updated at 01:06 PM ---------- Previous update was at 01:05 PM ----------
...

Lets say, you input file name is a.txt, then

awk '$3!=0 {print }' a.txt

Hi All,
I have posted this issue in the forum, but i did not get any answer. If someone knows about it, could you please let me know hoiw to do it?
i am FTP the file from one server to another. The...

i thought of doing same, but only after i connect to Source server using FTP, i can check. In FTP, i cannot use -f option.