Help needed to modify search functionality


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Help needed to modify search functionality
# 1  
Old 04-01-2020
Help needed to modify search functionality

Hi Folks -


I have the following file:
Quote:
outbox/FINPLAN - Entity_692.dat
outbox/FINPLAN - Entity_694.dat
outbox/FINPLAN - Entity_695.dat
outbox/FINPLAN_1084.dat
outbox/FINPLAN_1126.dat
outbox/FINPLAN_1130.dat
outbox/FINPLAN_1142.dat
outbox/FINPLAN_1185.dat
outbox/FINPLAN_1201.dat
outbox/FINPLAN_1221.dat
outbox/FINPLAN_1245.dat
outbox/FINPLAN_1247.dat
outbox/FINPLAN_1301.dat
outbox/FINPLAN_1303.dat
outbox/FINPLAN_1443.dat
outbox/FINPLAN_1503.dat
outbox/FINPLAN_1562.dat
outbox/FINPLAN_1661.dat
outbox/FINPLAN_1662.dat
outbox/FINPLAN_1701.dat
outbox/FINPLAN_1741.dat
outbox/FINPLAN_1781.dat
outbox/FINPLAN_1822.dat
outbox/FINPLAN_1864.dat
outbox/FINPLAN_1881.dat
outbox/FINPLAN_1944.dat
outbox/FINPLAN_FILE_1101.dat
outbox/FINPLAN_FILE_1128.dat
outbox/FINPLAN_FILE_1131.dat
outbox/FINPLAN_FILE_1132.dat
outbox/FINPLAN_FILE_1144.dat
outbox/FINPLAN_FILE_531.dat
outbox/logs/FINPLAN_2141.log
outbox/logs/FINPLAN_2161.log
outbox/logs/FINPLAN_2181.log
outbox/logs/FINPLAN_2201.log
This file is exported after various steps of my data integration routine. I need to be able to dynamically download the latest logfile from this list that starts with a path of " outbox/logs/", all other entries can be ignored.



I have the following code which works if I know the name of the log:
Code:
_FDMEE_LOG="$(sort -r temp.txt | sed -n "\#${_OUTBOX_BIN}FINPLAN_# {s#.*/##; p; q}")"

I need to be able to find the latest file, regardless of the name as long as it starts with " outbox/logs/". I tried to add a wildcard to the above logic but it doesn't work. Can someone help me editing my syntax?


THe result should be : outbox/logs/FINPLAN_2201.log based on my sample data.



Thank you!

Last edited by SIMMS7400; 04-01-2020 at 09:18 PM..
# 2  
Old 04-02-2020
Hi
how about?
Code:
grep '^outbox\/logs\/' temp.txt | tail -1

--- Post updated at 11:35 ---

maybe so
Code:
grep '^outbox\/logs\/' temp.txt | sort -t_ -nk2,2.4 | tail -1

or
Code:
grep '^outbox\/logs\/' temp.txt | sort -V | tail -1

These 2 Users Gave Thanks to nezabudka For This Post:
# 3  
Old 04-02-2020
They all worked flawlessly!!! Thank you so much!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pattern search and modify the values

I have one file and the file may contain 500 to 15,000 records. I need to search pattern ^F509= and then increment the corresponding value by one and print the entire line. Please note that Its not a fixed length file. Can anyone please help? ex: ^F509=204656 ^F509=204656 ... (6 Replies)
Discussion started by: vinus
6 Replies

2. Shell Programming and Scripting

Faster search needed

Hope you guys out there can help. I have 2 files as below: file 1: 111,222,333,444,555,666 777,888,999,000,111,222 111,222,333,444,555,888 file 2: 666,AAA 222,BBB 888,CCC I want to get the 6th column from file 1 (example, 666) and check in file 2 for the value in the 2nd column... (9 Replies)
Discussion started by: daytripper1021
9 Replies

3. Shell Programming and Scripting

Search for a pattern and replace. Help needed

I have three variables $a, $b and $c $a = file_abc_123.txt $b = 123 $c = 100 I want to search if $b is present in $a. If it is present, then i want to replace that portion by $c. Here $b = 123 is present in "file_abc_123.txt", so i need the output as "file_abc_100.txt' How can this be... (3 Replies)
Discussion started by: irudayaraj
3 Replies

4. Shell Programming and Scripting

Help needed with basic search

hi, im trying to find the longest word in /usr/share/dict/words that does not contain the letter i. i've tried using the wc -L command like so: $ wc -L /usr/share/dict/words which basically tells me the longest word which is good but how do i get the longest word which Does not contain the... (7 Replies)
Discussion started by: tryintolearn
7 Replies

5. Shell Programming and Scripting

Printing 10 lines above and below the search string: help needed

Hi, The below code will search a particular string(say false in this case) and return me 10 lines above and below the search string in a file. " awk 'c-->0;$0~s{if(b)for(c=b+1;c>1;c--)print r;print("***********************************");print;c=a;}b{r=$ 0}' b=10 a=10 s="false" " ... (5 Replies)
Discussion started by: vimalm22
5 Replies

6. Shell Programming and Scripting

Help with search and delete/add/modify script

Gurus, I need to run a script on multiple XML files in different directories and do the following (the output can be redirected to create a new file) 1. Search a pattern like "abc.mno.xyz" in an XML file, once detected, the script should delete one line above and 3 lines below (including the... (2 Replies)
Discussion started by: inditopgun
2 Replies

7. UNIX for Dummies Questions & Answers

modify a particular pattern starting from second line of the search pattern

Hi, I think you ppl did not get my question correctly, let me explain I have 1.txt with following entries as shown: 0152364|134444|10.20.30.40|015236433 0233654|122555|10.20.30.50|023365433 ** ** ** In file 2.txt I have the following entries as shown: ... (1 Reply)
Discussion started by: imas
1 Replies

8. UNIX for Dummies Questions & Answers

modify a particular pattern starting from second line of the search pattern

Hi, I am new to this forum and i would like to get help in this issue. I have a file 1.txt as shown: apple banana orange apple grapes banana orange grapes orange .... Now i would like to search for pattern say apple or orange and then put a # at the beginning of the pattern... (2 Replies)
Discussion started by: imas
2 Replies

9. UNIX for Advanced & Expert Users

search a replace each line- help needed ASAP

can someone help me with the find and replace command. I have a input file which is in the below format: 0011200ALN00000000009EGYPT 000000000000199900000 0011200ALN00000000009EGYPT 000000000000199900000 0011200ALN00000000008EGYPT 000000000000199800000 0011200ALN00000000009EGYPT ... (20 Replies)
Discussion started by: bsandeep_80
20 Replies

10. UNIX for Dummies Questions & Answers

Help needed in search string

Hi , I learning shell scripting.. I need to do the following in my shell script. Search a given logfile for two\more strings. If the the two strings are found. write it to a outputfile if only one of the string is found, write the found string in one output file and other in other... (2 Replies)
Discussion started by: amitrajvarma
2 Replies
Login or Register to Ask a Question