Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extract date and time part from filename
Top Forums UNIX for Beginners Questions & Answers Extract date and time part from filename Post 303033762 by Prathmesh on Thursday 11th of April 2019 10:52:36 AM
Old 04-11-2019
Quote:
Originally Posted by RudiC
Good grief! What a heck of a problem. We have a "race condidtion" of what pattern occurs first in the pattern file and what occurs first in the string. When found a pattern, and reduced the string, we need to start over with the first pattern again. I think I have found a solution; try and report back:
Code:
FNR == 1        {FILENR++
                }

FILENR <= 2     {CHFM = CHFM DL $1
                 RGEX[$1] = $2
                 DOTS[$1] = $3
                 FMTS[$1] = $4
                 FIDX[$1] = FILENR
                 DL = "|"
                 next
                }

                {printf "%s", $0
                 for (j=4; j<=5; j++)   {TMP = $j
                                         PTR = 0
                                         while (match (TMP, CHFM))      {MTCH = substr (TMP, RSTART, RLENGTH)
                                                                         printf "|%s|%s|%s|%s|%s", PTR + RSTART, RLENGTH, MTCH, DOTS[MTCH], FMTS[MTCH]
                                                                         TMP = substr (TMP, RSTART+RLENGTH)
                                                                         PTR += RSTART + RLENGTH - 1
                                                                         TYP[j-3,FIDX[MTCH]]++
                                                                        }
                                        }
                 for (j=1; j<=2; j++) printf "|%s|%s", TYP[j,1]+0, TYP[j,2]+0
                 print ""
                 split ("", TYP)
                }
'  FS=","  file[45] FS="|" OFS="|" file3
SOURCE|LOGIN|SERVER|ABC_123_YYYYMMDD_V01P1234YYMMDDHHMISS.txt|ABC_123_V01P.YYYYMMDD.HHMISS.txt|CATEGORY|9|8|YYYYMMDD|........|%Y%m%d|26|6|YYMMDD|......|%y%m%d|32|6|HHMISS|......|%H%M%S|14|8|YYYYMMDD|........|%Y%m%d|23|6|HHMISS|......|%H%M%S|2|1|1|1
SOURCE|LOGIN|SERVER|ABC_123_YYYYMMDD_V01P1234YYMMDD.HHMISS.YYYY-MM-DD.txt|ABC_123_V01P.YYYYMMDD.HHMISS.txt|CATEGORY|9|8|YYYYMMDD|........|%Y%m%d|26|6|YYMMDD|......|%y%m%d|33|6|HHMISS|......|%H%M%S|40|10|YYYY-MM-DD|....-..-..|%Y-%m-%d|14|8|YYYYMMDD|........|%Y%m%d|23|6|HHMISS|......|%H%M%S|3|1|1|1
SOURCE|LOGIN|SERVER|ABC_123_YYYYMMDD_V01P1234YYMMDD.HHMISS.YYYY-MM-DD.XXXXXXXXXX.txt|ABC_123_V01P.YYYY-MM-DD.YYYYMMDD.HHMISS.XXXXXXXXXX.txt|CATEGORY|9|8|YYYYMMDD|........|%Y%m%d|26|6|YYMMDD|......|%y%m%d|33|6|HHMISS|......|%H%M%S|40|10|YYYY-MM-DD|....-..-..|%Y-%m-%d|51|10|XXXXXXXXXX|..........|%s|14|10|YYYY-MM-DD|....-..-..|%Y-%m-%d|25|8|YYYYMMDD|........|%Y%m%d|34|6|HHMISS|......|%H%M%S|41|10|XXXXXXXXXX|..........|%s|3|2|2|2
SOURCE|LOGIN|SERVER|P_XYZ_1234_ABCD.YYYYMMDD.HHMISS.csv|Report.ABCD_csv.YYYYMMDD.HHMISS.csv|CATEGORY|17|8|YYYYMMDD|........|%Y%m%d|26|6|HHMISS|......|%H%M%S|17|8|YYYYMMDD|........|%Y%m%d|26|6|HHMISS|......|%H%M%S|1|1|1|1

Thank you so much RudiC for your valuable time and help. Solution works perfectly fine.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Insert date/time within a filename

Hi Guys, I need to script the renaming of files as followins: files: firstjd secondjo thirdjv My script needs to insert the date/time infront of the last 2 characters of the filenames above, any ideas greatly received :) the letters before the last 2 characters could change, I'm only... (7 Replies)
Discussion started by: cooperman
7 Replies

2. Shell Programming and Scripting

Extract date from filename and create a new file

Hi, i have a filename CRED20102009.txt in a server 20102009 is the date of the file ddmmaaaa format the complete route is /dprod/informatica/Fuentes/CRED20102009.csv i want to extract the date to create a new file named Parameters.txt I need to create Parameters.txt with this... (6 Replies)
Discussion started by: angel1001
6 Replies

3. Shell Programming and Scripting

how to update date part with new increment date time

hi experts, my requirement is like this i need to develop a shell script to update date part with new incremental date time in file some 'X' which is kept at some server location incrementing every two hours.as i am new to this scripting i need support from u people,thanx in advance (1 Reply)
Discussion started by: amanmro
1 Replies

4. Shell Programming and Scripting

Extract date from filename and set timestamp

I have lots of files in this format: dvgrab-2003.06.29_15-30-24.mpg The numbers represents the date and time (YYYY.MM.DD_HH-MM-SS) How can I extract the dates from the filenames, and use the dates in the file timestamp? I guess this can be done by using "find", "sed" and "touch"? Can... (6 Replies)
Discussion started by: qwerty1234
6 Replies

5. Shell Programming and Scripting

append a filename with system date and time

Hi, There are similar kind of posts, but none seems like working for me. Please correct me if I'm wrong. I need append/rename file abc.txt with file processed date and time like abc_systemdatetimestamp.txt and move it to different folder. for example I have /source/data/abc.txt ... (1 Reply)
Discussion started by: amsn08
1 Replies

6. UNIX for Dummies Questions & Answers

to extract all the part of the filename before a particular word in the filename

Hi All, Thanks in Advance I am working on a shell script. I need some assistance. My Requirement: 1) There are some set of files in a directory like given below OTP_UFSC_20120530000000_acc.csv OTP_UFSC_20120530000000_faf.csv OTP_UFSC_20120530000000_prom.csv... (0 Replies)
Discussion started by: aealexanderraj
0 Replies

7. Programming

to extract all the part of the filename before a particular word in the filename

Hi All, Thanks in Advance I am working on a shell script. I need some assistance. My code: if then set "subscriber" "promplan" "mapping" "dedicatedaccount" "faflistSub" "faflistAcc" "accumulator"\ "pam_account"; for i in 1 2 3 4 5 6 7 8;... (0 Replies)
Discussion started by: aealexanderraj
0 Replies

8. Shell Programming and Scripting

Extract a part of a filename containing a particular word

Hi All, Thanks in Advance Shell Script or Perl Script I am working on a shell script. I need some assistance. My Requirement: 1) There are some set of files in a directory like given below OTP_UFSC_20120530000000_acc.csv OTP_UFSC_20120530000000_faf.csv... (7 Replies)
Discussion started by: aealexanderraj
7 Replies

9. UNIX for Dummies Questions & Answers

Extract Date part from the filename

Hi All, I have incoming source files abcmmyy.txt I need to extract the mmyy part from the filename and pass that to a variable . I really appreciate your quick response on this. Thanks raj (7 Replies)
Discussion started by: rajeevm
7 Replies

10. UNIX for Beginners Questions & Answers

How to extract date and time from filename?

Hi, I'm totally new in sell script and working with a shell code. I want to extract the date and time from the filenames. The filenames are different but all of them begins with WI_ SCOPE_: WI_SCOPE_DATA_CHANGE_2017-09-12_15-30-40.txt WI_SCOPE_BACK_COMPLETE_QUEUE_2017-09-12_15-31-40.txt... (5 Replies)
Discussion started by: Home
5 Replies

LEARN ABOUT HPUX

evmeventnamematchstr

EvmEventNameMatch(3)					     Library Functions Manual					      EvmEventNameMatch(3)

NAME

       EvmEventNameMatch(), EvmEventNameMatchStr() - match EVM event name

SYNOPSIS

   Library
       EVM Support Library

   Parameters
       pattern	     The  event name pattern sought.  The pattern may be any valid event name string.  It may include wildcard characters in place
		     of any component.

       event	     The event containing the event name to be compared against the pattern.

       match	     The result of the match. This operand is set to if the name matches the pattern, and to if it does not.

       candidate     A character string to be matched against the pattern

DESCRIPTION

       Because special matching rules apply when deciding whether a candidate event name matches a known name, the  EVM  name  matching  functions
       should  be  used  for matching purposes, rather than the C string comparison functions The EVM functions match an event name against a sup-
       plied pattern, ignoring any trailing appended components in the candidate name, and correctly matching wildcard characters.

       The function takes an event and an event name pattern as input, and returns an indication of  whether  the  event  contains  a  name  which
       matches the pattern in the match output argument.  The pattern may be any valid event name string, and may also include wildcard characters
       in place of any component.  A wildcard in the pattern matches zero or more name components.  A matches  exactly	one  component.   A  match
       occurs if the event name matches all components indicated by the pattern, even if the name has additional trailing elements.

       The function performs the same check as but takes a character string as the candidate event name, instead of extracting the candidate event
       name from a supplied event.

       Both functions set the match output argument to if the name matches the pattern, and to if it does not.

RETURN VALUE

       The operation completed without error.  The comparison was successful.  The value of the match operand indicates whether the  name  matches
       the pattern.

       One of the arguments to the function is invalid.
	      The supplied pattern contains invalid characters.

       The supplied event does not contain a name.

ERRORS

       The value of is not set.

SEE ALSO

   Routines
       memccpy(3C), strcat(3C).

   Event Management
       EVM(5).

   EVM Events
       EvmEvent(5).

															      EvmEventNameMatch(3)
All times are GMT -4. The time now is 04:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy