Finding consecutive numbers in version names on a txt file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Finding consecutive numbers in version names on a txt file
# 8  
Old 03-14-2011
Quote:
Originally Posted by Chubler_XL
Code:
awk -F'[-.]' '$1==p&&$(NF-1)==n {print f}; {n=$(NF-1)+1; p=$1;f=$0}' infile

Thanks, Chubler_XL. This works nearly perfectly, except that there's more than one dash in the entries.

This would be one line:
E4-Z61-7393486-001.jpg

Buy I can just compare $1, $2 and $3.

---------- Post updated at 12:36 PM ---------- Previous update was at 12:16 PM ----------

Finally, and for lack of a better version, this is what I've used, and it works:

Code:
nawk 'BEGIN {FS="[-.]"} $(NF-1)==n&&$1==a&&$2==b&&$3==c {print f}; {n=$(NF-1)+1; a=$1;b=$2;c=$3;f=$0}' kk

Thank you very much for your help, guys.
# 9  
Old 03-14-2011
This might be a little more robust as it supports any number of dashes:

Code:
nawk 'BEGIN {FS="[-.]"} {b=$0; sub(/\-[0-9][0-9]*.[^.]*/, "", b);} $(NF-1)==n&&b==a {print f}; {n=$(NF-1)+1; a=b;f=$0;}' kk

# 10  
Old 03-17-2011
Quote:
Originally Posted by Chubler_XL
This might be a little more robust as it supports any number of dashes:

Code:
nawk 'BEGIN {FS="[-.]"} {b=$0; sub(/\-[0-9][0-9]*.[^.]*/, "", b);} $(NF-1)==n&&b==a {print f}; {n=$(NF-1)+1; a=b;f=$0;}' kk


Hmmm, I don't get your substitution. Let's see:
\- -> A slash
[0-9] -> A number
[0-9]* -> Zero or more numbers
. -> Any character
[^.]* -> Zero or more characters that are not a dot

And then you clear it? Am I misunderstanding this? When I try the sub in the test name I gave, it just turns:
E4-Z61-7393486-001.jpg
into:
E4-Z61.jpg
by removing the substring:
-7393486-001

I believe you might have wanted to remove from "b" the substring -001? Maybe then we could use as a regexp:
Code:
/\-[0-9][0-9][0-9]\./

This User Gave Thanks to fox1212 For This Post:
# 11  
Old 03-17-2011
Quote:
Originally Posted by fox1212
I believe you might have wanted to remove from "b" the substring -001?
Thanks, I actually wanted to remove from "b" the substring -001.jpg so correct code is (change shown in red):
Code:
nawk 'BEGIN {FS="[-.]"} {b=$0; sub(/\-[0-9][0-9]*\.[^.]*/, "", b);} $(NF-1)==n&&b==a {print f}; {n=$(NF-1)+1; a=b;f=$0;}' kk

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Delete files whose file names are listed in a .txt file

hi, I need a help. I used this command to list all the log files which are for more than 10 days to a text file. find /usr/script_test -type f -mtime +10>>/usr/ftprm.txt I want all these files listed in the ftprm.txt to be ftp in another machine and then rm the files. Anyone can help me... (8 Replies)
Discussion started by: kamaldev
8 Replies

2. UNIX for Dummies Questions & Answers

finding overlapping names in different txt files

Dear Gurus, I have 57 tab-delimited different text files, each one containing entries in 3 columns. The first column in each file contains names of objects. Some names are present in more than one file. I would like to find those names and store them in a separate text file, preferably with a... (6 Replies)
Discussion started by: Unilearn
6 Replies

3. Shell Programming and Scripting

Print numbers along with file names.

Hi All, I have some thousand files with names like 1.syl, 2.syl, 5.syl etc. These files contain one sentence each. I want to store all those sentences along with the file ID that is 1, 2, 5 with the sentences they contain. For example, 1.syl has this is a test line 2.syl has ... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies

4. Shell Programming and Scripting

Finding consecutive same words in a file

Hi All, I tried this but I am having trouble formulating this: I have a file that looks like this (this is a sample file words can be different): network router frame network router computer card host computer card One can see that in this file "network" and "router" occur... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies

5. UNIX for Dummies Questions & Answers

Extract numbers from .txt file

I need to extract all the p-value numbers and the rho numbers from a .txt file and write them as coma separated values in a new file. Ideally I would get two files in the end, one for p- values and one for rho. Any suggestions? I appreciate your help!!! The .txt file looks essentially like this... (5 Replies)
Discussion started by: eggali
5 Replies

6. UNIX for Advanced & Expert Users

How to select only those file names whose name contains only numbers

Hi Guru's, Before writing to this forum I have searched extensively on this forum about my problem. I have to write a shell script which takes out only those file names from the given directory which contains only numbers. For example, In the given directory these files are present: ... (4 Replies)
Discussion started by: spranm
4 Replies

7. UNIX for Dummies Questions & Answers

How to select only those file names whose name contains only numbers.

Hi Guru's, Before writing to this forum I have searched extensively on this forum about my problem. I have to write a shell script which takes out only those file names from the given directory which contains only numbers. For example, In the given directory these files are present: ... (0 Replies)
Discussion started by: spranm
0 Replies

8. Shell Programming and Scripting

Inserting a range of consecutive numbers into a text file

I have a text file in the following format .... START 1,1 2,1 3,1 .. .. 9,1 10,1 END .... I want to change to the output to .... START 1,1 2,1 3,1 .. (4 Replies)
Discussion started by: VNR
4 Replies

9. Shell Programming and Scripting

how to remove files with only numbers as file names?

Hi all, I have a bunch of files that are named like 12543, 467249877, etc all over some directories.These files are named only with numbers, they dont have any letters or special characters in their file names. Could you please help me out and give me some command/script to remove only those... (6 Replies)
Discussion started by: praveen_indramo
6 Replies

10. Shell Programming and Scripting

[Urgent]how to print the file names into a txt file???

HI, I have a folder with some 120 files...i just want to print all the file filenames(not the content or anything else) onto a file say .txt. please help me with this command Thanks a lot. (15 Replies)
Discussion started by: kumarsaravana_s
15 Replies
Login or Register to Ask a Question