Visit Our UNIX and Linux User Community


Pattern search and save it as .txt file with some name..


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Pattern search and save it as .txt file with some name..
# 1  
Old 06-10-2011
Pattern search and save it as .txt file with some name..

Hello,
I have a note pad at /usr/abc location with the following content, since it is a huge file i need to split it into multiple .txt files.

Code:
A123|akdhj      |21kjsdff  |b212b1b21 |0
A123asdasd     |assdd     |asdasdsdqw|6
A123|QEWQ    |NMTGHJK |zxczxczx|3
A123|GEGBGH  |RTYBN    |xcvvxc|2
A123|VDFGER  |RYRYRTY |QRRWR|6
A123|RGEDFB   |YRTYTR |DFGDGDG|1
A123|DFRER    |WT3YTY |DGDGFG|2
A123|DFBDB    |QRQR     |QRQRQ|6
A123|DBDB     |WEWER   |QQQWER|8
A123|DBDBB   |WERWER  |YJTYJTY|0
Z213             |fasf        |afaf|afaffa|23
Z213             |asf        |afaf|afaffa|0
Z213             |FDDS        |afaf|afaffa|89
Z213             |RWER       |afaf|afaffa|8
Z213             |fQWE        |afaf|afaffa|8
Z213             |sdfdsf        |afaf|afaffa|7
Z213             |bfgh        |afaf|afaffa|3
Z213             |erter        |afaf|afaffa|1
Z213             |tyutyu        |afaf|afaffa|3
Z213             |rtret        |afaf|afaffa|9
Z213             |werwe        |afaf|afaffa|1

Above is the ac.txt file with huge content like this some starting with A123 some with Z213 and so on...
Now my requirement.

I want to read this file first search for A123 and save it in some other location containg all the records of A123, then search for Z213 and save it in some other location containg all the records of Z213 and so on..
Please suggest.
# 2  
Old 06-10-2011
Code:
for i in A213 Z213
do
 grep $i ac.txt > /tmp/$i.txt
done

# 3  
Old 06-10-2011
Try this.

Few assumptions made,

1. First four chars of each line is taken as the matcing pattern
2. output file will be created with matching pattern.txt format

Code:
awk  '{print $0 >>substr($0,0,4)".txt"}'  test.txt

# 4  
Old 06-10-2011
Code:
awk -F'[ |]' '{print > $1".txt"}' inputfile

# 5  
Old 06-10-2011
Quote:
Originally Posted by michaelrozar17
Code:
awk -F'[ |]' '{print > $1".txt"}' inputfile

What about second row of the sample input ?
# 6  
Old 06-10-2011
Oops!! I didn notice that precise..
Code:
awk '{print > substr($0,0,4)".txt"}' inputfile

# 7  
Old 06-10-2011
Ok, i will try and will comment.
But i hope the above all solution is searching the pattern and then copying all the contents starting with A123 and putting it in some txt file and again searching pattern "Z213 " and again putting it in some other txt file.

Also i hope its copying the whole content starting with A123 and Z213; and not only A123 and Z213.

Last edited by j_panky; 06-10-2011 at 05:44 AM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #589
Difficulty: Medium
A binary search algorithm requires that the array being searched is sorted in descending order.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Save files in directory as txt

wget -x -i link.txt The above downloads and create unique entries for the 97 links in the text file. However, each new file is saved as CM080 with a FILE extention. Is there a way to convert each file in that directory to a .txt? The 97 files are in... (12 Replies)
Discussion started by: cmccabe
12 Replies

2. Shell Programming and Scripting

How to use sed to search a particular pattern in a file backward after a pattern is matched.?

Hi, I have two files file1.txt and file2.txt. Please see the attachments. In file2.txt (which actually is a diff output between two versions of file1.txt.), I extract the pattern corresponding to 1172c1172. Now ,In file1.txt I have to search for this pattern 1172c1172 and if found, I have to... (9 Replies)
Discussion started by: saurabh kumar
9 Replies

3. Shell Programming and Scripting

Get the input from user and save it as .txt file

Hi friends, I am pretty new to shell scripting, please help me in this Scenario. for example, If I have one file called input.txt once I run the script, 1.It has to delete the old input.txt and create the new input.txt (if old input.txt is not there, no offence, just it has to create a... (2 Replies)
Discussion started by: Padmanabhan
2 Replies

4. Shell Programming and Scripting

Search for a pattern in a String file and count the occurance of each pattern

I am trying to search a file for a patterns ERR- in a file and return a count for each of the error reported Input file is a free flowing file without any format example of output ERR-00001=5 .... ERR-01010=10 ..... ERR-99999=10 (4 Replies)
Discussion started by: swayam123
4 Replies

5. Shell Programming and Scripting

Want to read data from a file name.txt and search it in another file and then matching...

Hi Frnds... I have an input file name.txt and another file named as source.. name.txt is having only one column and source is having around 25 columns...i need to read from name.txt line by line and search it in source file and then save the result in results file.. I have a rough idea about the... (15 Replies)
Discussion started by: ektubbe
15 Replies

6. Shell Programming and Scripting

"Time" command and save result in a file.txt

Hi, I'am using "time" to check execution time of some script. Is there any possibility to save time command result into a file ? (2 Replies)
Discussion started by: Physix
2 Replies

7. UNIX for Dummies Questions & Answers

Save Excel file as .txt in UNIX format

I have some files created in Excel that have to be saved as .txt files in order to load them into our accounting system. I can save the files as .txt files through Excel, but I then have to open them in TextPad and do a save as to change the Format from PC to UNIX. Is there a way to skip this step... (2 Replies)
Discussion started by: jroyalty
2 Replies

8. Shell Programming and Scripting

How search,edit and save the file

Hi All, I want to edit a file using shell script..For ex...a file called /etc/passwd..here I am searching for "ftp" if it is there just change it to "tftp" without using any temporary file. (3 Replies)
Discussion started by: Vichu
3 Replies

9. Shell Programming and Scripting

replace character in a string pattern and save the change in same file

I am facing one problem, can any one please suggest me the command for the same in unix. I am using Ksh. I have a large file with the data that looks like below. "ROTO2-2007f","_US01","9/15/2007","9/21/2007",346492,"NICK, LCD WATCH"97,1,"NAPOLITJ ","BERGER,M Z & CO INC",0.01, ... (2 Replies)
Discussion started by: mihir0011
2 Replies

10. Shell Programming and Scripting

Search file for pattern and grab some lines before pattern

I want to search a file for a string and then if the string is found I need the line that the string is on - but also the previous two lines from the file (that the pattern will not be found in) This is on solaris Can you help? (2 Replies)
Discussion started by: frustrated1
2 Replies

Featured Tech Videos