Sponsored Content
Top Forums Shell Programming and Scripting How to copy Content of a file to another file on a specific column Post 302343904 by tuxus on Friday 14th of August 2009 04:13:17 AM
Old 08-14-2009
Hi, thank you for the reply.

The file2 contains commands for mysql (generated with a converting tool):
Quote:
insert into records (domain_id, name,type,content,ttl,prio) select id ,'10.3.2.1.', 'PTR', 'nameofserver.', 172800, 0 from domains where name='in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id ,'10.3.2.2.', 'PTR', 'nameofserver.', 172800, 0 from domains where name='in-addr.arpa';
.
.
.
.
.
insert into records (domain_id, name,type,content,ttl,prio) select id ,'10.3.2.254.', 'PTR', 'nameofserver.', 172800, 0 from domains where name='in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id ,'10.3.2.255.', 'PTR', 'nameofserver.', 172800, 0 from domains where name='in-addr.arpa';
And file1 has only one column:

Quote:
1.2.3.10.in-addr.arpa
2.2.3.10.in-addr.arpa
3.2.3.10.in-addr.arpa
.
.
.
253.2.3.10.in-addr.arpa
254.2.3.10.in-addr.arpa
255.2.3.10.in-addr.arpa
Both files have 255 lines.

What i need is the file2 like this:

Code:
insert into records (domain_id, name,type,content,ttl,prio) select id ,'1.2.3.10.in-addr.arpa', 'PTR', 'nameofserver.', 172800, 0 from domains where name='in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id ,'2.2.3.10.in-addr.arpa', 'PTR', 'nameofserver.', 172800, 0 from domains where name='in-addr.arpa';
.
.
.

 

10 More Discussions You Might Find Interesting

1. AIX

find for specific content in file in the directory and list only file names

Hi, I am trying to find the content of file using grep and find command and list only the file names but i am getting entire file list of files in the directory find . -exec grep "test" {} \; -ls Can anyone of you correct this (2 Replies)
Discussion started by: madhu_Jagarapu
2 Replies

2. Shell Programming and Scripting

Bash copy file contents into an existing file at a specific location

Hi all I need to copy the entire contents of one file into an existing file at a specific location. I know the exact line number where I need to put it. It appears I would use either sed or awk to do this, but I have been unsuccessful so far: File A line 1 line 2 line 3 line 4 ... (6 Replies)
Discussion started by: gshepherd7
6 Replies

3. UNIX for Dummies Questions & Answers

How to copy entire file content into another file being in last line mode of vi ?

How to copy entire file content into another file being in last line mode of vi ? ---------- Post updated at 10:07 AM ---------- Previous update was at 09:56 AM ---------- Got it : :1,30w file.txt (1 Reply)
Discussion started by: presul
1 Replies

4. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies

5. Shell Programming and Scripting

Adding content of two file in a single file column wise

Hi, I am trying to get the file in particular pattern using shell script. I have to add one column to some other file. For example consider two file as below. File1: name1 name2 name3 File2: Add1 age1 Add2 age2 Add3 age3 I want this two file in a single file format something like... (3 Replies)
Discussion started by: diehard
3 Replies

6. Shell Programming and Scripting

Change the file name and copy old file content to new file names.

Hi, I have a files in a directory as below :- ls -1 mqdepth-S1STC02 proc-mq-S1STC01 proc-mq-S1STC02 proc-mq-S1STC03 Whereever i have S1STC i need to copy them into new file with file name S2STC. expected output :- ls -1 mqdepth-S2STC02 proc-mq-S2STC01 proc-mq-S2STC02... (3 Replies)
Discussion started by: satishmallidi
3 Replies

7. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies

8. UNIX for Beginners Questions & Answers

Insert content from file 1 to file 2 in specific criteria meet

Hi , I'm looking for some code that can copy and paste form file1 to file2 with 2 criterial meet. file1: test "sp-j1" test "sp-j2" test "sp-j3" test "sp-j4" file2: sub Pre_Shorts1 (Status_Code, Message$) global Status !if Message$ <> "" then print... (3 Replies)
Discussion started by: kttan
3 Replies

9. Shell Programming and Scripting

Appending content of a file to another file before a specific character

Hi there, i've got a file with this content $ cat file1 Matt Mar The other file has the same number of lines with this content: $ cat file2 20404=767294 23450=32427 is there a way with either using sed, awk or paste to insert the content of file1 before the "=" character? So... (3 Replies)
Discussion started by: nms
3 Replies

10. UNIX for Beginners Questions & Answers

Copy the content from txt file and create a html file

I have a txt file with a list of error messages in a xml tag format, and each error message is separated with a identifier(endresult).Need to split that and copy and create a new html file.Error message has some special character. how to escape the special character and insert my data into the... (7 Replies)
Discussion started by: DevAakash
7 Replies
ADDR2ASCII(3)						   BSD Library Functions Manual 					     ADDR2ASCII(3)

NAME
addr2ascii, ascii2addr -- Generic address formatting routines LIBRARY
Standard C Library (libc, -lc) SYNOPSIS
#include <arpa/inet.h> char * addr2ascii(int af, const void *addrp, int len, char *buf); int ascii2addr(int af, const char *ascii, void *result); DESCRIPTION
The routines addr2ascii() and ascii2addr() are used to convert network addresses between binary form and a printable form appropriate to the address family. Both functions take an af argument, specifying the address family to be used in the conversion process. (Currently, only the AF_INET and AF_LINK address families are supported.) The addr2ascii() function is used to convert binary, network-format addresses into printable form. In addition to af, there are three other arguments. The addrp argument is a pointer to the network address to be converted. The len argument is the length of the address. The buf argument is an optional pointer to a caller-allocated buffer to hold the result; if a null pointer is passed, addr2ascii() uses a statically- allocated buffer. The ascii2addr() function performs the inverse operation to addr2ascii(). In addition to af, it takes two arguments, ascii and result. The ascii argument is a pointer to the string which is to be converted into binary. The result argument is a pointer to an appropriate network address structure for the specified family. The following gives the appropriate structure to use for binary addresses in the specified family: AF_INET struct in_addr (in <arpa/inet.h>) AF_LINK struct sockaddr_dl (in <net/if_dl.h>) AF_INET and AF_LINK constants are defined in <sys/socket.h> RETURN VALUES
The addr2ascii() function returns the address of the buffer it was passed, or a static buffer if the a null pointer was passed; on failure, it returns a null pointer. The ascii2addr() function returns the length of the binary address in bytes, or -1 on failure. EXAMPLES
The inet(3) functions inet_ntoa() and inet_aton() could be implemented thusly: #include <sys/socket.h> #include <arpa/inet.h> char * inet_ntoa(struct in_addr addr) { return addr2ascii(AF_INET, &addr, sizeof addr, 0); } int inet_aton(const char *ascii, struct in_addr *addr) { return (ascii2addr(AF_INET, ascii, addr) == sizeof(*addr)); } In actuality, this cannot be done because addr2ascii() and ascii2addr() are implemented in terms of the inet(3) functions, rather than the other way around. ERRORS
When a failure is returned, errno is set to one of the following values: [ENAMETOOLONG] The addr2ascii() routine was passed a len argument which was inappropriate for the address family given by af. [EPROTONOSUPPORT] Either routine was passed an af argument other than AF_INET or AF_LINK. [EINVAL] The string passed to ascii2addr() was improperly formatted for address family af. SEE ALSO
inet(3), linkaddr(3), inet(4) HISTORY
An interface close to this one was originally suggested by Craig Partridge. This particular interface originally appeared in the INRIA IPv6 implementation. AUTHORS
Code and documentation by Garrett A. Wollman, MIT Laboratory for Computer Science. BUGS
The original implementations supported IPv6. This support should eventually be resurrected. The NRL implementation also included support for the AF_ISO and AF_NS address families. The genericity of this interface is somewhat questionable. A truly generic interface would provide a means for determining the length of the buffer to be used so that it could be dynamically allocated, and would always require a ``struct sockaddr'' to hold the binary address. Unfortunately, this is incompatible with existing practice. This limitation means that a routine for printing network addresses from arbi- trary address families must still have internal knowledge of the maximum buffer length needed and the appropriate part of the address to use as the binary address. BSD
June 13, 1996 BSD
All times are GMT -4. The time now is 11:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy