Search Results

I think the below will work well, if you not like to replace the files on the same directory


while `read line`
do
sed 's/apple/orange/g' $line > <NewPath>/$line
done < changes.txt
...

Thanks you all for quick resposne. sorry I think i m not clear with my initial query.

Scripts should run like this ": ksh encrypt.ksh <input file> <Length> > Outputfile

Inputfile = different...

Hi,

I am in critical need of help, Thanks a ton for your help.

I need to know how to pass the shell argument into nawk code in AIX. so that my file gets passed into that awk script and it can...

Hi,

We have scheduled few jobs/scripts in cron and it runs on daily basis at a specified time. We have a cron jobs has various parameters for main scripts like

/home/test/mainscript.ksh...

Hi champs,

I have one of the requirement, where I need to compare two files line by line and ignore duplicates. Note, I hav files in sorted order.

I have tried using the comm command, but its...

Thanks all for your input and the code, it worked like a champ.. you help is always appreciated.. thank you so much

---------- Post updated at 07:43 PM ---------- Previous update was at 07:41 PM...

Thanks for your responses. the post by akshey has worked like a champ for 3 columns, but it missed to print .. in between the column, but its fine.

Now the requirement has been changed, its having...

Thanks for your prompt response, but its not giving the output which is expected, instaed its giving as below


Database1..Table1..col1
Database1..Table1..col2
Database1..Table1..col2
..
...
...

I have tied the below,i knew there is some logic is missing, unable to capture it.


olddb=""
oldtb=""
while `read line`
do
DB=`echo $line | awk -F' ' '{print $1}'`
TB=`echo $line | awk -F' '...

hi experts,

I have a flat file with below contents

Database1 Table1 column1
Database1 Table1 column2
Database1 Table1 column3
Database1 Table1 column4
Database1 Table2 Column1
Database1...

Thanks for your response.

The requirement is to compare two files (which has "database name"|"Tablename"|"Column1,column2,column3") in this pattern, but there might be a mismatch in number of...

hi all,

Thanks to all for your great help...

I have a scenario that I have two files (file1 & file2). I need to compare two files entire row by row and share the output if any discrepancies...

Hi,

Is there any way that we can pass one file as one of the argument in shell script ?

yeah.. thank you so much, itworked...

Oldfile

LONDON
HUNGARY
Budapest
california

Newfile

HUNGARY
california
North carolina
India
LONDON
Budapest
Switzerland


Output should be:

I need to compare two files (oldfile1 & newfile). Need to ignore the values which are present in both files. At the same time, i need to get only records in new file.

Tried using Join -v1 -v2...

Thanks veri for your response.

the scenario goes like this,

I am getting all table list and from that using sp_help <tablename> getting the column list which has char/varchar.

Those details...

Hi, I am new to advanced scripting.

I need to get top 20 records from database (Sybase) with a condition that all Char/varchar columns should have more than 4 characters.

I need to do this via...