Search Results

Thank you very much......

Hi all,

I have a requirement to connect DB2 database and do some operations and generate a report through shell script.

Can anyone please tell me how can i connect DB2 from unix shell script?...

Hi all,
I have a requirement to replace a field with a character as per the length of the field.
Suppose i have a file where second field is of 20 character length. I want to replace second field...

As i am working in AIX, there is no "-i" option in sed

Hi all,

I have a huge file(size more that 5GB).
I want to do some manupulation with the records and write to another file.
As the size of the file is huge and there is a space constraint in...

Hi..

I need the input variables in an input file... like:-

a=1;b=2;c=3;d=4;e=5; -----> in an input file

This is because, i have more than 100 variables used here. And if in future i...

awk -F'|' 'BEGIN{a=1;b=2;c=3;d=4;e=5} {if($1=a){...} if($2=b){...}....}' < input_file

The command is like this...

I want to put all the variable used here like a,b,c,d,e in a separate file......

Hi all,

I have a requirement to put all the varibles used in an awk command in a separate file. This is because i have arround 100 variables used in an awk command. So i want to put all the...

hi all,

I need a help for below requirement.

Difference between two dates"12-11-2009" and "03-25-2012" (mm-dd-yy format") in weeks and days and hours

Please help me for this. Thanks in...

Dear Balajesuri,

No, i dont have GNU date.
I am working in AIX system

Dear Balajesuri,

Thanks for your reply. I have used the below command, but it is not working , i have korn shell, please help me for this..
awk '{while IFS='|' read a b c; do echo "$a|`date -d$b...

Hi all,

I have a file with below data
af23b|11-FEB-12|acc7
ad23b|12-JAN-12|acc4
as23b|15-DEC-11|acc5
z123b|18-FEB-12|acc1

I need the output as below:-(date in yyyymmdd format)...

Dear agama,

Actually i hv the problem like, putting the excel file in unix location is not in our hand. There is an excel file present in unix location(a third party vandor has put it), we have...

Hi all..

Please help me on below requirement.

I have an excel file ftped from windows to unix location. I am not able to open the file. if i am opening it in vi editor, i am getting only...

Hi Kalpeer,

\( ..... \) :- this is called save operator, what ever you will put in side this like \(abc\), will be stored in unix system buffer(\1..\9). There are 9 system buffers present in unix...

Hi...

I have an inputfile name as :- abc_test_20120213.dat (date in yyyymmdd format)

I need the output file name as abc_test_13022012.dat (date in ddmmyyyy format)

Please help me on...

Hi friends...

This comand is working fine, but facing an issue while having the input like below:-

abc,ttt,"""24,123,89.98",yyu,opp
vvv,"1,423,76.68",w564,"54,98.87",985...

Now, the above two commands working fine

Thank you ...

ls>Directorylisting.txt

Hi friends...

I have a dat file like below:-

test_file.dat

abc,ttt,"""123,89.98",yyu,opp
vvv,"23,76.68",w564,"54,98.87",985


i need the remove the comma present inside the double...

sed 's/||$//g' filename.csv

Thanks all...
The command is working fine.

Can we put the output file as file1?? (the original file should be my output file).

Hi,
I have two files with below data::
file1:-
123|aaa|ppp
445|fff|yyy
999|ttt|jjj
555|hhh|hhh

file2:-
445|fff|yyy
555|hhh|hhh

The records present in file1, not present in file 2...

Hi ahamed,
I think the option "-i" is shell specific. This command is working fine in bash, but not working in ksh. Please suggest me if you have any suggestions(code). thanks...

Hi jayan_jay,...

Thanks Ahamed.
But I think your code needs an output file for writing the output. I need to modify the input file as the size of the input file is large.