Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

look for specific values in a file and rename file with value found

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers look for specific values in a file and rename file with value found
# 1  
Old 07-01-2012
look for specific values in a file and rename file with value found
Hi,
i have a file with some data ..look for some specific value in the file and if found that value rename the file with the value found in the file..
ex..
File.txt
1236 43715825601ANDERSSON,
1236 437158256031963040120060901200609010000000
1236 43715825604123 MCCL AVE UPPER
1236 43715825605AMSTERDAM NY 120100000
1236 43715825611A756
1236 43715825633100620120215I00000007819GOR
1236 43715825633100620120215F00000020850GOR
1237 11868184001BEAUREGARD, TAMMY L 0F
1237 11868184003196812272001113020011130000000000000000000
1237 118681840041566 SALT SPRINGVILLE
1237 11868184005FORT PLAIN NY 133390000
1237 11868184011A756
need to fine the value A756(in place of A756 we can have any of the value from these...A756 or B234 or C987 ) if we found any of the value with in the file the file name should be changed to File_ValueFound.txt
ex: File_A756.txt
the place of value is same always..

Thanks in advance..
Siva Santosh

# 2  
Old 07-02-2012
Try this:
Code:
fv="A756"
v=`fgrep "$fv" test.txt`
if [[ -n $v ]]; then mv test.txt test_${fv}.txt; fi;

# 3  
Old 07-02-2012
The basic logic is bellow to find and rename files having a matching string. You can add multi sreach string as per your requirement.

PHP Code:
for filename in `grep -l AAA /root/ars/*`;
do
newname=$filename"AAA"
echo $newname
# move your file i=using mv command
done 
Last edited by amitranjansahu; 07-02-2012 at 02:15 AM.. Reason: code tag
# 4  
Old 07-02-2012
@Spacebar..
we dont know which one will be in the file ..it is either A756 or B234 or C987
# 5  
Old 07-02-2012
Try this if the position of the records is always going to be in the 5th line and the string is 4 characters,

Code:
mv file.txt File_`sed -n '5p' file.txt | awk '{print substr($0,(length($0)-3))}'`.txt

# 6  
Old 07-02-2012
Hi Athix,
the record position can be any where(not the 5th line each time) ...but the string length is always 4 characters..but if string exist it will be from 17th position from start of the line (any of the line)..
# 7  
Old 07-02-2012
Only these 3 strings A756 or B234 or C987 to check ??? If NO, then on what basis, we can get the values of string from the input file ..

Be clear while providing the input and dont let us assume. This would eaten up our time to provide answers ..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to change specific string to new value if found in text file

I am trying to use awk to change a specific string in a field, if it is found, to another value. In the tab-delimited file the text in bold in $3 contains the string 23, which is always right before a ., if it is present. I am trying to change that string to X, keeping the formatting and the... (3 Replies)
Discussion started by: cmccabe
3 Replies

2. Shell Programming and Scripting

Rename text file with a specific pattern in directory

I am trying to rename all text files in a directory that match a pattern. The current command below seems to be using the directory path in the name and since it already exists, will not do the rename. I am not sure what I am missing? Thank you :). Files to rename in... (3 Replies)
Discussion started by: cmccabe
3 Replies

3. Shell Programming and Scripting

Rename specific file extension in directory with match to another file in bash

I have a specific set (all ending with .bam) of downloaded files in a directory /home/cmccabe/Desktop/NGS/API/2-15-2016. What I am trying to do is use a match to $2 in name to rename the downloaded files. To make things a more involved the date of the folder is unique and in the header of name... (1 Reply)
Discussion started by: cmccabe
1 Replies

4. Shell Programming and Scripting

Rename values in file

Dear all, I have a problem that i cannot solve and I hope someone here can help me. I have a huge tab delimited text file with two columns in relation. The values in the first column can be redundant and one copy of that value can exist in the second column. My question is how to simplify... (5 Replies)
Discussion started by: Higgo
5 Replies

5. Shell Programming and Scripting

Get specific values from a file, help

Dear all, I have a specific problem that i cannot solve and I hope someone here can help me. :) I have two text files with one column of values. Example: File1: 67 94 95 . . File2 0.1 0.003 0.5 . . (3 Replies)
Discussion started by: Higgo
3 Replies

6. Shell Programming and Scripting

Rename the file with specific pattern

Hello I am making a script where I need to rename the files but with different names.The file name could be change according to the product I made a logic but that is not working properly arr=$(echo a@b@c | tr "@" "\n") echo $arr output is a b c arry=$(echo d@e@f | tr "@" "\n") ... (4 Replies)
Discussion started by: anuragpgtgerman
4 Replies

7. Shell Programming and Scripting

Rename a file based on a specific separator

Hello, I am new to shell I have a folder which contains a list of files, all the files contain the separator : I need to replace this character for all the filenames (by batch) ex: hello:world should become hello-world please help Thanks (3 Replies)
Discussion started by: sikilaklak
3 Replies

8. Shell Programming and Scripting

extract specific string and rename file

Hi all, I am working on a small prog.. i have a file.txt which contains random data... K LINES V4 ADD CODE `COMPANY` ADD CODE `DISTRIBUTOR` SEQ NAME^K LINES V5 SEQ NAME^K LINES V6 ADD `PACK-LDATE` SEQ NAME^K^KCOMMAND END^KHEADINFO... (1 Reply)
Discussion started by: mukeshguliao
1 Replies

9. Shell Programming and Scripting

to extract specific values twice in a file

Hi Friends, I have a file with the following values.. xyz.txt,12345.xml abc.txt,04567.xml cde.txt,12134.xml I would like to extract all the 2nd column values twice as shown in the example like 12345,12345.xml 04567,04567.xml 12134,12134.xml Please advice!! In the formus one of... (7 Replies)
Discussion started by: techmoris
7 Replies

10. UNIX for Dummies Questions & Answers

finding specific values in a within a file

Hi everyone, Can anyone guide me on how to search through a huge file and look on specific column and if it finds a discrepancy on that column that does not conform to the specified criteria, ie (1) Numeric and (3) alpha chars F123 or G333..etc, etc! then idientify it and redirect... (3 Replies)
Discussion started by: Gerry405
3 Replies
Login or Register to Ask a Question