Search Results

Sorry let me modify the requirement in the below way

let's say if my keyfile is as below

scls1,1000,a,b,c,d,p1
scls2,1001,a,b,c,d,p1
scls1,1000,a1,b1,c,d,p1
scls2,2000,a1,b,c,d,p1
...

Hi,

Thanks for the reply.
Desired o/p is as below

pg1,scls1
pg2,scls2

I was trying something like below
awk 'NR==FNR{a[$1] keyfile datafile

But not getting what to do next

Hi,

I need help in solving the below need in UNIX.

I have a file datafile as below


pg1,dvn1,scls1,cls1,itp1,sku1
pg2,dvn2,scls2,cls2,itp2,sku2


and keyfile as below

...

Hi All,

Many thanks for this quick help.
This is working and previous one was my mistake.

Hi RavinderSingh13,

Thanks.

I tried this one but it's making source file as zero byte and creating inclusion file as below.,,1,
,,2,
,,3,
,,4,
,,5,


Please wrap all code, files, input &...

Hi R. Singh,

Thanks for the reply.
It has worked for me but one change I require here.

I want to create records for first line only
Then do some internal process
then overwrite the same...

Hi,

I have a file source as below.

OL|10031|Day|Black|Midi|Good|Value|P01|P07
OL|10031|Day|Black|Short|Good|Value|P01|P07

I need to create a file form the above data as below logic

1....

Hi,

Thanks for reply.
AIX 1

Hi,

I need a suggestion for an issue in UNIX file.

I have a log file in my system where data is appending everyday and as a consequence the file is increasing heavily everyday.

Now I need a...

Hi All,

Thanks for the reply.
I have still below confusion.


ust to be complete, if one tells the command the limit is 5, it will start t scripts at once in paralell.
And then check every...

Hi,

Thanks for the reply.
So I understand if I run below it will run the 3 scripts in parallel.

test1.sh par1 &
test1.sh par2 &
test1.sh par3 &

Now I have 2 questions.

How UNIX...

Hi,

I'm trying to do teh below thing.

I have a single script which uses 3 different parameters to do 3 different work like belwo.

test1.sh par1 -- it shuts down an instance
test1.sh par2...

Hi Yoda,

I'm getting the error like this.

ORA-01461: can bind a LONG value


GV_script_error is assigned as a out parameter while calling a packaged function where out parameter in...

Thanks for the suggestions.
I didn't consider LOB datatypes.
How I will do this?

Hi,

I ahve a unix code as below.
sqlTxt=$*
sqlReturn=`echo "set feedback off;
set heading off;
set term off;
set verify off;
set serveroutput on size unlimited
set lin 1000;
VARIABLE...

Hi,

I want to do some added functionality in this file.
Now my file will ahve this type of text.



1. and 2. are the number s which will come along with previous message.This number cab...

Many thanks for this explanation.
It is totally clear now.

Thanks for your help. It worked.
Can you please explain me the code as I'm not very much efficient in awk.

Thanks for the reply.
Yes I want this thing along with

pkg1.func1: detail s 1111
pkg1.func1: detail s 222

which means pkg1.func1: will be coming everytime .

Hi ,

I need your help for the below issue.

I have a file which has data as below


An error came (/u01/app/12.csv)
pkg1.func1: detail s 1111-->pkg1.func1: detail s 2222-->

Now...

Hi,

Can anyone please help me in this?

Thanks in advance.

Hi,

Thanks for the reply.
I'm getting the below error.

awk: Cannot divide by zero when using the modulo operator.

Hi,

Thanks for this which is working fine.
Now i want to add timestamp while createting the file.

like i have a variable fileDate=`date +"%Y%m%d%H%M%S"` which i want to use in awk while...

Many thanks Yoda for this which is working fine.
I want another functionality here.
If the file contains the data as

Error is : error in dept 10;location 100;
Error is : error in dept...

Hi,

I need your help in creating a script for the below scenario.
I have a file which has below data.

Error is : error in dept 10;location 100;
Error is : file has this invalid supplier 10...