Visit Our UNIX and Linux User Community


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 10: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!

Previous Thread | Next Thread
Test Your Knowledge in Computers #97
Difficulty: Easy
Unix is a multi-user operating system where the same resources can be shared by different users even if they do not have the proper permissions to do so.
True or False?

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

Featured Tech Videos