Date Pattern Match (replacement string)


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date Pattern Match (replacement string)
# 1  
Old 10-28-2009
Date Pattern Match (replacement string)

Hello, i am splitting files and sometimes the string of the pattern doesnt exist in the input file it starts for example with 00:00:01. So the output is completely desorganized, is there any way of putting a replacement string in the pattern so it will grab all the times from 00:**:** to first occurence of 01:**:** ?



Code:
  awk 'NR==FNR && $2 ~ /00:00:00/,/01:00:00/{print $1" "$2" "$3;a[$3]+=1; next} END {for(x in a){print  "# of Ocurrences --->" x,"->",a[x]}}' 10-JUL-2009.out  > 10-JUL-2009-00:00:00-00:59:59.out

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pattern to match date in YYYY-MM-DD format on Linux machine

Hi Expert, Request your help. For date validation in csv file, i have written below code for linux machine I want the date to be in format 2017-05-11(YYYY-MM-DD), if not present in this format the error should be printed. Could you please help in finding the right pattern to match above date... (8 Replies)
Discussion started by: as7951
8 Replies

2. Shell Programming and Scripting

Sed:- Supported variable replacement after string match?

Hi All, I am trying to replace the variable in the file after the particular match string. It is being replaced if i hardcode the value and with use of "&" with sed. sed -e "s/URL./& http:\\localhost:7223/g" But when am trying to pass the variable it is failing. I tried multiple... (9 Replies)
Discussion started by: sharsour
9 Replies

3. Shell Programming and Scripting

Pattern Match & Extract from a string

Hi, I have long string in 2nd field, as shown below: REF1 | CLESCLJSCSHSCSMSCSNSCSRSCUDSCUFSCU7SCV1SCWPSCXGPDBACAPA0DHDPDMESED6 REF2 | SBR4PCBFPCDRSCSCG3SCHEBSCKNSCKPSCLLSCMCZXTNPCVFPCV6P4KL0DMDSDSASEWG I have a group of fixed patterns which can occur in these long strings & only... (11 Replies)
Discussion started by: karumudi7
11 Replies

4. Shell Programming and Scripting

pattern match in a string

Hello, Please see below line code: #!/bin/ksh set -x /usr/bin/cat /home/temp |while read line do if ] then echo "matched" else echo "nope" fi done content of filr temp is as below (4 Replies)
Discussion started by: skhichi
4 Replies

5. Shell Programming and Scripting

String replacement when particular pattern matches in a file

I have a file file123.xml which looks like this xmlEntry="username"="josh" <property="never_back_down"> phone="<178652>" apn=property:address="wonderland" xmlEntry="username"="jessica" <property="never_back_down"> phone="<178653>" apn=property:address="wonderland"... (5 Replies)
Discussion started by: poga
5 Replies

6. Shell Programming and Scripting

Using cat to match pattern start with particular date.

Hi All, version :- SunOS rdrsu1 5.10 Generic_142900-12 sun4u sparc SUNW,SPARC-Enterprise I have a requirenemet, where I have to extrace eroror start with ORA-, which match a perticular date. In below text I only extract out error coming on wed-8 and start with text like "ORA-". hope you... (4 Replies)
Discussion started by: alok.behria
4 Replies

7. Shell Programming and Scripting

Performing pattern match for a string that might be intermingle with other strings

I have a log file that display the serial output coming from different places. Sometime the string in search gets clobbered with the other strings and consequently change form. For example: serial ouput: -------------- hello world! done with network configuring asic registers comJan 1... (2 Replies)
Discussion started by: timmylita
2 Replies

8. Shell Programming and Scripting

Match pattern and replace with string

hi guys, insert into /*<new>*/abc_db.tbl_name this is should be replaced to insert into /*<new>*/${new}.tbl_name it should use '.' as delimiter and replace is there any way to do it using sed (6 Replies)
Discussion started by: sol_nov
6 Replies

9. Shell Programming and Scripting

pattern match url in string / PERL

Am trying to remove urls from text strings in PERL. I have the following but it does not seem to work: $remarks =~ s/www\.\s+\.com//gi; In English, I want to look for www. then I want to delete the www. and everything after it until I hit a space (but not including the space). It's not... (2 Replies)
Discussion started by: mrealty
2 Replies

10. UNIX for Advanced & Expert Users

how can awk match multi pattern in a string

Hi all, I need to category the processes in my system with awk. And for now, there are several command with similar name, so i have to match more than one pattern to pick it out. for instance: binrundb the string1, 2 & 3 may contain word, number, blank or "/". The "bin" should be ahead "rundb"... (5 Replies)
Discussion started by: sleepy_11
5 Replies
Login or Register to Ask a Question
FNMATCH(3)								 1								FNMATCH(3)

fnmatch - Match filename against a pattern

SYNOPSIS
bool fnmatch (string $pattern, string $string, [int $flags]) DESCRIPTION
fnmatch(3) checks if the passed $string would match the given shell wildcard $pattern. PARAMETERS
o $pattern - The shell wildcard pattern. o $string - The tested string. This function is especially useful for filenames, but may also be used on regular strings. The average user may be used to shell patterns or at least in their simplest form to '?' and '*' wildcards so using fnmatch(3) instead of preg_match(3) for frontend search expression input may be way more convenient for non-programming users. o $flags - The value of $flags can be any combination of the following flags, joined with the binary OR (|) operator. A list of possible flags for fnmatch(3) +-------------+---------------------------------------------------+ | $Flag | | | | | | | Description | | | | +-------------+---------------------------------------------------+ | | | |FNM_NOESCAPE | | | | | | | Disable backslash escaping. | | | | | | | |FNM_PATHNAME | | | | | | | Slash in string only matches slash in the given | | | pattern. | | | | | | | | FNM_PERIOD | | | | | | | Leading period in string must be exactly matched | | | by period in the given pattern. | | | | | | | |FNM_CASEFOLD | | | | | | | Caseless match. Part of the GNU extension. | | | | +-------------+---------------------------------------------------+ RETURN VALUES
Returns TRUE if there is a match, FALSE otherwise. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.3.0 | | | | | | | This function is now available on Windows plat- | | | forms. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 Checking a color name against a shell wildcard pattern <?php if (fnmatch("*gr[ae]y", $color)) { echo "some form of gray ..."; } ?> NOTES
Warning For now, this function is not available on non-POSIX compliant systems except Windows. SEE ALSO
glob(3), preg_match(3), sscanf(3), printf(3), sprintf(3). PHP Documentation Group FNMATCH(3)