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 303033661 by RudiC on Wednesday 10th of April 2019 04:52:22 AM
Old 04-10-2019
This is not easy a request, both to understand and to implement. I have understood that you want to search two input fields, $4 and $5, for date/Ttime format descriptors, and append their metadata to the line. Additional data that shows up in your desired output, as ......, |0|0|, or %Y%m%d are even harder to implement as specified. Try this a a first starting point:


Code:
awk -F"|" '
BEGIN   {MXFM = split ("YYYYMMDD|YYMMDD|HHMISS", FMT)
        }

        {printf "%s", $0
         for (j=4; j<=5; j++)   {TMP = $j
                                 PTR = 0
                                 for (i=1; i<=MXFM; i++) if (match (TMP, FMT[i]))       {printf "|%s|%s|%s|...", PTR + RSTART, RLENGTH, substr (TMP, RSTART, RLENGTH)
                                                                                         TMP = substr (TMP, RSTART+RLENGTH)
                                                                                         PTR += RSTART + RLENGTH - 1
                                                                                        }
                                }
         print ""
        }
'  OFS="|" file
SOURCE|LOGIN|SERVER|ABC_123_YYYYMMDD_V01P1234YYMMDDHHMISS.txt|ABC_123_V01P.YYYYMMDD.HHMISS.txt|CATEGORY|9|8|YYYYMMDD|...|26|6|YYMMDD|...|32|6|HHMISS|...|14|8|YYYYMMDD|...|23|6|HHMISS|...

and see how far it gets you.
This User Gave Thanks to RudiC For This Post:
Prathmesh
 

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 DEBIAN

ogmdemux

OGMDEMUX(1)							   User Commands						       OGMDEMUX(1)

NAME

       ogmdemux - Extract streams from OGG/OGM files into separate files

SYNOPSIS

       ogmdemux [options] inname

DESCRIPTION

       This program extracts all or only some streams from an OGM and writes them to separate files.

       inname Use 'inname' as the source.

       -o, --output out
	      Use  'out'  as  the  base  for  destination  file  names.  '-v1', '-v2', '-a1', '-t1'... will be appended to this name. Default: use
	      'inname'.

       -a, --astream n
	      Extract specified audio stream. Can be used more than once. Default: extract all streams.

       -d, --vstream n
	      Extract specified video stream. Can be used more than once. Default: extract all streams.

       -t, --tstream n
	      Extract specified text stream. Can be used more than once. Default: extract all streams.

       -na, --noaudio
	      Don't extract any audio streams.

       -nv, --novideo
	      Don't extract any video streams.

       -nt, --notext
	      Don't extract any text streams.  Default: extract all streams.

       -r, --raw
	      Extract the raw streams only.  Default: extract to useful formats (AVI, WAV, OGG, SRT...).

       -v, --verbose
	      Increase verbosity.

       -h, --help
	      Show this help.

       -V, --version
	      Show version number.

NOTES

       What works:

       *      Extraction of the following formats is fully supported including writing the stream contents to useful container formats:
		video  -> AVI
		Vorbis -> OGG/Vorbis
		PCM    -> WAV
		text   -> text files (SRT subtitle format)

       *      All other audio streams (MP3, AC3) are just copied 1:1 into output files. MP3 and AC3 files should be usable. Others might not.

       What not works:

       *      Headers created by older OggDS (DirectShow) filter versions are not supported (and probably never will be).

AUTHOR

       ogmdemux was written by Moritz Bunkus <moritz@bunkus.org>.

SEE ALSO

       ogmmerge(1), ogmsplit(1), ogminfo(1), ogmcat(1), dvdxchap(1)

WWW

       The newest version can always be found at <http://www.bunkus.org/videotools/ogmtools/> <http://www.bunkus.org/videotools/ogmtools/>

ogmdemux v1.5							   November 2004						       OGMDEMUX(1)
All times are GMT -4. The time now is 11:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy