Search Results

Output file should be like this

val1 id1 machine name user (IP Address1)
val2 id2 machine name user (IP Address2)
val4 ...

I have two files like

File1 : will get this file from "who" command. It is a unix file.

user val1 Jul 29 13:15 (IP Address1)
user val3 Jul 30 03:21 (IP Address2)
user ...

Hi,

I used sed command to replace õ character.
sed -n '1,$s/õ/o/gp' inputfile > outputfile

The problem is there are 5 records in input file and 2 records has that õ character. So after using...

Hi,

Iam new to unix. Is there any way to get the sql code "ORA-01847" into a variable.

sqlplus username/password@database name << EOF
set heading off
update TempTable set variable where...

Hi,

I have one file to FTP from Unix to mainframe. It has been successfully FTPied. But problem is my Unix file will be generated as file_name1.sh. But Mainframes side they need file in...

:b: It works .............. Thanks Zaxxon

Hi, Iam new to unix. I have one input file .

Input file :

ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3

I need output such that only first column should change to fixed width column...

Thanks Danmero and vgresh99 for the reply. But still I have some another problem. If I have my file as

File1:

Col1 Col2 ID
2008-06-02|12.36.06|1-432
2008-06-01|23.36.35|1-345

In the above...

Hi, I have a column in a table of Timestamp datatype. For Example : Var1 is the column 2008-06-26-10.10.30.2006. I have Given query as date(var1) and time (var1) I got the file as in the below format...

Hi, Thanks for the reply.I have given the above command .... Its working for all the records except for first record......... Please let me know how to append the values for first record also.

Hi, I have a file....

File1:

Num Name ID Place ADDR City Country
1024|Name1|ID1|Street1|ADDR1|Boston|UK
1025|Name2|ID3|Street2|ADDR2|London|USA

The above file is varaiable...

I have tried using awk and nawk but I could not able to get it. Please let me know how to get out of this issue...

Hi, I have two input files.

File1:

ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary

File1 is a variable length file where each column is seperated by delimitter...

Hi, I have two input files.

File1:

ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary

File1 is a variable length file where each column is seperated by delimitter...

Thanks franklin for that reply. But I heard that we can do a validation on the delimiter "~" and can divide the record using SUBSTR command and can replace the column by another column of another...

Thanks for the reply. I have tried this but when Iam trying to use awk its not working .... but nawk works instead. Is there any alternative thing where I can write a shell scripting to replace Place...

Hi, I have two input files.

File1:

ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary

File1 is a variable length file where each column is seperated by...

Thanks Franklin...... I got the desired output By giving the following connamd..........

nawk 'NR==FNR{a[$1]=$2;next} a[$1]{print $1, $2;next}{print $1}' file2 file1 > file3

Thanks Once...

Thanks for the reply......I have tried by giving the command...............

awk 'NR==FNR{a[$1]=$2;next}{print $1, a[$1]}' File1 File2

or

nawk 'NR==FNR{a[$1]=$2;next}{print $1, a[$1]}' File1...

Hi, I have two files.

File1:

File1 contains two fixed width columns ID of 15 characters length and Name is of 100 characters length.

ID Name
1-43<<11...

Thanks a lot...... I have given gawk instead of awk its working now........ Thanks again.....................

Hi, I have input file.

File1:

Seqno Name
121 name1
122 name2
123 name3
124 name4

We will send the file1 to some other team. They will replace name column with place in file1 and send...

Thanks for reply. But when I gave the below command.

awk 'NR==FNR{a[$1]=$2;next}{print $1 " " a[$1]}' file2 file1

The output file is as shown below :

124
121
123
124
121
123
122

I...

Hi, I have input file.

File1:

Seqno Name
124 name1
121 name2
123 name3
122 name4

We will send the file1 to some other team. They will replace name column with place in file1 and send...

I have done some modifications to be clear on my question. Please can anyone help me on above question ? :(