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 303033694 by RudiC on Wednesday 10th of April 2019 09:34:46 AM
Old 04-10-2019
Hmmmm - not quite clear yet when you want the dots, and when the printf format strings, or when both... See how far this gets you:



Code:
awk '
FNR == 1        {FILENR++
                }
FILENR <= 2     {CNT++
                 CHFM[CNT] = $1
                 RGEX[CNT] = $2
                 DOTS[CNT] = $3
                 FMTS[CNT] = $4
                 next
                }
                {printf "%s", $0
                 for (j=4; j<=5; j++)   {TMP = $j
                                         PTR = 0
                                         for (i=1; i<=CNT; i++) if (match (TMP, CHFM[i]))       {printf "|%s|%s|%s|%s|%s", PTR + RSTART, RLENGTH, CHFM[i], DOTS[i], FMTS[i]
                                                                                                 TMP = substr (TMP, RSTART+RLENGTH)
                                                                                                 PTR += RSTART + RLENGTH - 1
                                                                                                }
                                        }
                 print ""
                }
'  FS=","  *format.csv FS="|" OFS="|" RECORD
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

These 2 Users Gave Thanks to RudiC For This Post:
Neo 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 REDHAT

tek4957

TEK4957(4x)															       TEK4957(4x)

NAME

       tek4957 - Tektronix 4957 input driver

SYNOPSIS

       Section "InputDevice"
	 Identifier "idevname"
	 Driver "tek4957"
	 Option "Device"   "devpath"
	 ...
       EndSection

DESCRIPTION

       tek4957 is an XFree86 input driver for the Tektronix 4957 tablet.

       The tek4957 driver functions as a pointer input device, and may be used as the X server's core pointer.

CONFIGURATION DETAILS

       Please  refer  to  XF86Config(5x)  for general configuration details and for options that can be used with all input drivers.  This section
       only covers configuration details specific to this driver.

	       Option "Device" "devpath"
		   sets the path to the special file which represents serial line where the tablet  is	plugged,  for  example	/dev/ttyS0.   This
		   option is mandatory.

	       Option "DeviceName" "name"
		   sets the name of the X device.

	       Option "Speed" "number"
		   sets the sampling rate, from 1 to 6.  Default is 6, maximum speed.

	       Option "Resolution" "number"
		   sets the resolution.
		       0 : 2340 dots  : 1/200 inch
		       1 : 2972 dots  : 1/10 mm
		       2 : 11700 dots : 1/1000 inch
		       3 : 11887 dots : 1/40 mm
		       4 : 5850 dots  : 1/500 inch
		       5 : 5944 dots  : 1/20 mm : default
		       6 : 4680 dots  : 1/400 inch
		       7 : 1170 dots  : 1/100 inch
		       8 : 12 dots    : 1 inch
		       9 : 24 dots    : 1/2 inch

	       Option "TopX" "number"
		   X coordinate of the top corner of the active zone. ( Default = 0 )

	       Option "TopY" "number"
		   Y coordinate of the top corner of the active zone. ( Default = 0 )

	       Option "BottomX" "Inumber"
		   X coordinate of the bottom corner of the active zone. ( Default = full scale )

	       Option "BottomY" "number"
		   Y coordinate of the bottom corner of the active zone. ( Default = full scale )

BUGS 
/ LIMITATIONS
       Currently, only "Absolute" mode is supported ( Sorry )

SEE ALSO

       XFree86(1), XF86Config(5x), xf86config(1), Xserver(1), X(7x).

AUTHORS

       Olivier DANET <odanet@caramail.com>

XFree86 						       Version Version 4.3.0						       TEK4957(4x)
All times are GMT -4. The time now is 04:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy