Advanced string search + selection


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Advanced string search + selection
# 1  
Old 10-04-2012
Advanced string search + selection

Hi All,

I want to run a script that will search backwards through a text file until it finds a certain string, something like "Date/Time/Eng" and select a string which happens to be a date and save that as a variable.

The line will always be in the following exact format:

Date/Time/Eng. : YYYY-MM-DD / HH:MM / XXXX ZZ

where I want to save the bold date and time as a variable (START).
(I will later use this variable as a start value to calculate time elapsed between START and END)

Also I am assuming that the string will be recognized as a date + time by UNIX.

I have a script that can select all text between two strings and output it to a text file but I'm too inexperienced to adapt that.

Could someone provide some help please?

Thanks in advance

M
# 2  
Old 10-04-2012
Like this?
Code:
START=$(awk '/Date\/Time\/Eng/{s=$3 " " $5}END{print s}' file)

# 3  
Old 10-04-2012
Hey,

do I replace "file" with the filepath/filename?

Thanks for the reply btw
# 4  
Old 10-04-2012
Quote:
Originally Posted by martin0852
do I replace "file" with the filepath/filename?
Yes.
# 5  
Old 10-04-2012
Thank you

---------- Post updated at 01:03 PM ---------- Previous update was at 07:14 AM ----------

Hi,

I have been trying to get this to work without any joy,

The following is the code I am using (please excuse any fundamental mistakes) EDIT: By excuse I meant be patient with me, please do, of course point out the mistakes

Code:
#/usr/xpg4/bin/awk

START=$(awk '/Date\/Time\/Eng/{s=$3 " " $5}END{print s}' /usr/asm/atl.0000/user_data/error_logs/ASML_LOGBOOK.TXT) 

END=$(date +%Y-%m-%d, date +%H:%M, "")
DIFF=$(( $END - $START ))
echo "Total downtime = $DIFF"

When I run this on my UNIX machine (running SunOS 5.10) the following is displayed:

Quote:
./downtime.sh
Variable syntax
I have a feeling I am doing something wrong either with the first line or the awk command.

Last edited by martin0852; 10-04-2012 at 09:10 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to use a grep search to search for a specific string within multiple directories?

Lets say I have a massive directory which is filled with other directories all filled with different c++ scripts and I want a listing of all the scripts that contain the string: "this string". Is there a way to use a grep search for that? I tried: grep -lr "this string" * but I do not... (3 Replies)
Discussion started by: Circuits
3 Replies

2. What is on Your Mind?

Update to Advanced Search Page (Phase 1)

Update: I have completed the first phase of revamping the "Advanced Search" page using Bootstrap (desktop not mobile yet): https://www.unix.com/search.php https://www.unix.com/search.php I may change this to a Bootstrap modal later and change the CSS a bit more; but for now it is much... (0 Replies)
Discussion started by: Neo
0 Replies

3. What is on Your Mind?

Moved Advanced Stats to Search Results Pages

FYI, today I moved the "Advanced Stats" page from the forum home page to the search results pages. This means that at the top of the search results like "Today's Post" and "New Posts" and keyword searches, the stats will appear at the top of that page instead of the home page. The reason of... (3 Replies)
Discussion started by: Neo
3 Replies

4. What is on Your Mind?

Reformatted Advanced UNIX.COM Search Page (Desktop)

Just enabled Bootstrap for the advanced forum search page (desktop view): https://www.unix.com/search.php That' page still needs work, and to be converted from <table> elements to <div> elements, and to be redesigned, but in the meantime, it's OK using Bootstrap CSS. Note: Before, we had... (0 Replies)
Discussion started by: Neo
0 Replies

5. Shell Programming and Scripting

Search string within a file and list common words from the line having the search string

Hi, Need your help for this scripting issue I have. I am not really good at this, so seeking your help. I have a file looking similar to this: Hello, i am human and name=ABCD. How are you? Hello, i am human and name=PQRS. I am good. Hello, i am human and name=ABCD. Good bye. Hello, i... (12 Replies)
Discussion started by: royzlife
12 Replies

6. Shell Programming and Scripting

Search one string and then search another string in the next line

I am unable to use grep comman to Print only EmpPosition and if the EmpID next line. So output should be both EmpPosition and EmpID and also EmpPosition and EmpID data should match. Sample Data EmpPosition "New" EmpID "New" - - EmpPosition "New" ... (4 Replies)
Discussion started by: onesuri
4 Replies

7. Shell Programming and Scripting

Search several string and convert into a single line for each search string using awk command AIX?.

I need to search the file using strings "Request Type" , " Request Method" , "Response Type" and by using result set find the xml tags and convert into a single line?. below are the scenarios. Cat test Nov 10, 2012 5:17:53 AM INFO: Request Type Line 1.... (5 Replies)
Discussion started by: laknar
5 Replies

8. Shell Programming and Scripting

Advanced Search & Delete Text File

I have a file in which email messages are stored in. Every email is separated by by a ^Z character (Control-Z). I need to extract all emails after the 65,00th one to another file and delete them from the original file. Any suggests on accomplishing this? (2 Replies)
Discussion started by: maxcell
2 Replies

9. Shell Programming and Scripting

Perl: Search for string on line then search and replace text

Hi All, I have a file that I need to be able to find a pattern match on a line, search that line for a text pattern, and replace that text. An example of 4 lines in my file is: 1. MatchText_randomNumberOfText moreData ReplaceMe moreData 2. MatchText_randomNumberOfText moreData moreData... (4 Replies)
Discussion started by: Crypto
4 Replies

10. Post Here to Contact Site Administrators and Moderators

Advanced Search Problems.. Search by User Name

There seems to be some problems with Advanced Searching (by User Name & Keyword). I will try to fix this by upgrading vB soon. Thanks for your patience. Neo (1 Reply)
Discussion started by: Neo
1 Replies
Login or Register to Ask a Question