Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to pass strings from a list of strings from another file and create multiple files?
Top Forums UNIX for Beginners Questions & Answers How to pass strings from a list of strings from another file and create multiple files? Post 302995646 by nubie2linux on Monday 10th of April 2017 01:43:45 AM
Old 04-10-2017
How to pass strings from a list of strings from another file and create multiple files?
Hello Everyone ,

Iam a newbie to shell programming and iam reaching out if anyone can help in this :-

I have two files
1) Insert.txt
2) partition_list.txt

insert.txt looks like this :-
Code:
insert into emp1 partition (partition_name) 
(a1,
b2,
c4,
s6,
d8)
select 
a1,
b2,
c4,
s6,
d8
from emp partition (partition_name);
commit;


partition_list.txt looks like this :-
Code:
aemp_sec_01P2011_1
yemp_sec_01P2011_4
aemp_sec_01P2011_3
aemp_sec_01P2011_8
aemp_sec_01P2011_10
aemp_sec_01P2012_14
aemp_sec_01P2014_39
aemp_sec_01P2016_10

Each string in the partition_list.txt should replace both the "partition_name" string in the insert.txt file and create a new file for each string used in the partition_list.txt . How can this be achieved without opening the files and modifying . how can it be done through sed or awk ?

For ex :- The end o/p would be 8 new files. sample file will be :-

Code:
cat insert_aemp_sec_01P2011_1.txt
insert into emp1 partition (aemp_sec_01P2011_1) 
(a1,
b2,
c4,
s6,
d8)
select 
a1,
b2,
c4,
s6,
d8
from emp partition (aemp_sec_01P2011_1);
commit;

Code:
cat insert_yemp_sec_01P2011_4.txt
insert into emp1 partition (yemp_sec_01P2011_4) 
(a1,
b2,
c4,
s6,
d8)
select 
a1,
b2,
c4,
s6,
d8
from emp partition (yemp_sec_01P2011_4);
commit;

so there should be 8 like to be generated based on each line in partition_list.txt.


Iam sorry if i havent used to code tag button ...i apologise .
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

best method of replacing multiple strings in multiple files - sed or awk? most simple preferred :)

Hi guys, say I have a few files in a directory (58 text files or somthing) each one contains mulitple strings that I wish to replace with other strings so in these 58 files I'm looking for say the following strings: JAM (replace with BUTTER) BREAD (replace with CRACKER) SCOOP (replace... (19 Replies)
Discussion started by: rich@ardz
19 Replies

2. UNIX for Dummies Questions & Answers

Grep multiple strings in multiple files using single command

Hi, I will use below command for grep single string ("osuser" is search string) ex: find . -type f | xarg grep -il osuser but i have one more string "v$session" here i want to grep in which file these two strings are present. any help is appreciated, Thanks in advance. Gagan (2 Replies)
Discussion started by: gagan4599
2 Replies

3. UNIX for Dummies Questions & Answers

Delete strings in file1 based on the list of strings in file2

Hello guys, should be a very easy questn for you: I need to delete strings in file1 based on the list of strings in file2. like file2: word1_word2_ word3_word5_ word3_word4_ word6_word7_ file1: word1_word2_otherwords..,word3_word5_others... (7 Replies)
Discussion started by: roussine
7 Replies

4. UNIX for Dummies Questions & Answers

Find Multiple Strings from a list of *.gz files withour decompressing...

Hello Team, There is this situation where there are around 20 *.gz files and i want to search multiple words from all those files. Example as below : filea.gz fileb.gz filec.gz now i want to search words "hi" and "hello" from all these 3 files without... (4 Replies)
Discussion started by: varun87
4 Replies

5. Shell Programming and Scripting

Delete lines in file containing duplicate strings, keeping longer strings

The question is not as simple as the title... I have a file, it looks like this <string name="string1">RZ-LED</string> <string name="string2">2.0</string> <string name="string2">Version 2.0</string> <string name="string3">BP</string> I would like to check for duplicate entries of... (11 Replies)
Discussion started by: raidzero
11 Replies

6. Shell Programming and Scripting

Take a list if strings from a file and search them in a list of files and report them

I have a file 1.txt with the below contents. -----cat 1.txt----- 1234 5678 1256 1234 1247 ------------------- I have 3 more files in a folder -----ls -lrt------- A1.txt A2.txt A3.txt ------------------- The contents of those three files are similar format with different data values... (8 Replies)
Discussion started by: realspirituals
8 Replies

7. Shell Programming and Scripting

Extract two strings from a file and create a new file with these strings

I have the following lines in a log file. It would be great if some one can help me to create a new file with the just entries in the below format. 66.150.161.195 HPSAC=Z05 66.150.161.196 HPSAC=A05 That is just extract the IP address and the string DPSAC=its value 66.150.161.195 -... (1 Reply)
Discussion started by: Tuxidow
1 Replies

8. Shell Programming and Scripting

Search & Replace: Multiple Strings / Multiple Files

I have a list of files all over a file system e.g. /home/1/foo/bar.x /www/sites/moose/foo.txtI'm looking for strings in these files and want to replace each occurrence with a replacement string, e.g. if I find: '#@!^\&@ in any of the files I want to replace it with: 655#@11, etc. There... (2 Replies)
Discussion started by: spacegoose
2 Replies

9. Shell Programming and Scripting

Trying to take file numbers from a file, pass them to sed to change strings in corresponding lines

I have a bunch of file numbers in the file 'test': I'm trying the above command to change all the instances of "H" to "Na+" in the file testsds.pdb at the line numbers indicated in the file 'test'. I've tried the following and various similar alternatives but nothing is working: cat test |... (3 Replies)
Discussion started by: crunchgargoyle
3 Replies

10. UNIX for Beginners Questions & Answers

Use strings from nth field from one file to match strings in entire line in another file, awk

I cannot seem to get what should be a simple awk one-liner to work correctly and cannot figure out why. I would like to use patterns from a specific field in one file as regex to search for matching strings in the entire line ($0) of another file. I would like to output the lines of File2 which... (1 Reply)
Discussion started by: jvoot
1 Replies

LEARN ABOUT REDHAT

pdbtxt2html

pdbtxt2html(1)						      General Commands Manual						    pdbtxt2html(1)

NAME

       pdbtxt2html - Doc Text to HTML converter for Palm Pilots

SYNOPSIS

       pdbtxt2html [ -t ] file.txt [ file.html ]
       pdbtxt2html -v

DESCRIPTION

       pdbtxt2html converts text converted from a Doc(4) file via txt2pdbdoc(1) to HTML.  If no HTML filename is given, the generated HTML is sent
       to standard output.

   Document Title
       The first line of the file is used for the HTML document title.

   Bookmarks
       The last line of the file is examined and, if it contains a string enclosed between < and >, that is taken to be the bookmark marker.   The
       entire file is then scanned looking for lines beginning with it (ignoring leading whitespace).  These lines are converted to HTML headings.

       The  number  of whitespace characters after the first bookmark marker is used for heading level 1.  The level of subsequent headings is set
       to the number of whitespace characters between the bookmark marker and the bookmark text minus the number for the first bookmark plus one.

   Embedded URLs
       Valid URLs (according to RFC 1630) embedded in the text are turned into hyperlinks.  The ftp, gopher, http, https,  mailto,  news,  telnet,
       and wais URLs are recognized.

OPTIONS

       -t   Compile a table of contents and insert it between the first heading and the body.

       -v   Print the version number to standard output and exit.

EXAMPLE

       To convert a Doc file to HTML:

	    txt2pdbdoc alice.pdb alice.txt
	    pdbtxt2html alice.txt alice.html

SEE ALSO

       html2pdbtxt(1), txt2pdbdoc(1), doc(4), pdb(4)

       Tim Berners Lee.  Universal Resource Identifiers in WWW, Network Working Group of the Internet Engineering Task Force, June 1994.
	    http://info.internet.isi.edu/in-notes/rfc/files/rfc1630.txt

AUTHOR

       Paul J. Lucas <pauljlucas@mac.com>

txt2pdbdoc							 January 21, 2005						    pdbtxt2html(1)
All times are GMT -4. The time now is 08:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy