Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Perl script to extract last date field (yyyy/mm/dd)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Perl script to extract last date field (yyyy/mm/dd)
# 1  
Old 01-09-2009
MySQL Perl script to extract last date field (yyyy/mm/dd)
Hi Friends,

I've a special requirement, even though I know how to implement this using shell scripting, current requirement is PERL, in which I'm not much familiar !!!.

I've a record, which has around 200 fields, out of which I need to extract only one date value from the 97th field (this field itself has many comma seperated values including date values). Below is one such an example record (observation need more attention to identify fields).

field1, field2,.....,field96,
("2008/12/17 2009/03/16 0.000000 0.000000 2009/03/16,
2009/03/16 2009/06/15 0.000000 0.000000 2009/03/18,
.......................,,
2009/03/16 2009/06/15 0.000000 0.000000 2009/03/18"),
field98,.....,field200

My requirement is to extract the second date field (marked with blue, underlined) from the last sub-field (this is also comma separated) of the field 97.

Any help would be much appreciated on this challenging task!!!

Thanks in advance / Mysore Ganapati.
# 2  
Old 01-09-2009
The most obvious way would be to use 'split' to break the record into an array of fields. Syntax for split is
Quote:
@array = split /PATTERN/, EXPR, LIMIT
where EXPR will be your entire record and PATTERN is a regular expression that defines how to split the record. LIMIT (if present) is (simplicticly) the maximum number of times to split the line up.
But it's not clear, to me at least, where your field separators are. Are they white space or commas?

Are the brackets relevant? Are they the only ones in the line in which case you could match "(.*)" to extract your 97th element.

Once you have the 97th element, split it again.

Hope that helps, but not sure it will!Smilie

Jerry
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Date format change from mm/dd/yyyy to yyyymmdd in comma seperate line in perl

Hi All, I have line ,A,FDRM0002,12/21/2017,,0.961751583,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, it contains date in mm/dd/yyyy format i want to change this to yyyymmdd format using perl. Use code tags, thanks. (8 Replies)
Discussion started by: vishal0746
8 Replies

2. Shell Programming and Scripting

Date format YYYY/MM/DD to DD/MM/YYYY

I am getting output of YYYY-MM-DD and want to change this to DD/MM/YYYY. When am running the query in 'Todd' to_date(column_name,'DD/MM/YYYY') am getting the required o/p of DD/MM/YYYY, But when am executing the same query(Netezza) in linux server(bash) am getting the output of YYYY-MM-DD file... (3 Replies)
Discussion started by: Roozo
3 Replies

3. UNIX for Dummies Questions & Answers

Epoch date to YYYY/MM/DD or MM/DD/YYYY

I've seen a lot of posts on this and have tried the following: echo 1257000000| perl -e '($d,$m,$y)=(localtime(time-86400));$m+=1;$y+=1900;printf "$y/$m/$d\n";' But I am unable to convert a past Epoch date into a format such as YYYY/MM/DD or MM/DD/YYYY. I am using bash and don't know... (4 Replies)
Discussion started by: newbie2010
4 Replies

4. Shell Programming and Scripting

Converting date DD MM YYYY to DD MON YYYY

Hello, I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10) To extract the dates, I am using shell substrings, i.e.: read line ... (4 Replies)
Discussion started by: Adamm
4 Replies

5. Shell Programming and Scripting

Shell script for Date conversion from mm/dd/yy to mm/dd/yyyy

Seek help in coverting date from mm_dd_yy to mm_dd_yyyy. I get a date in a file some thing file like this 09_14_11.pdf Need to convert the same to 09_14_2011.pdf :wall: (9 Replies)
Discussion started by: aakishore
9 Replies

6. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

(Attention: Green PHP newbie !) I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Discussion started by: keyboarder
6 Replies

7. Shell Programming and Scripting

PERL String to Date (Custom format yyyymmdd to dd-mon-yyyy)

Hi All, I am learning PERL for one of the projects, and in one of these scripts, I read a flat text file and print in the terminal. The problem is, the text file has a date field. The format is yyyymmdd. I need to display this as dd-mon-yyyy. Any ideas to do this? Thanks a lot for the... (9 Replies)
Discussion started by: guruparan18
9 Replies

8. UNIX for Dummies Questions & Answers

Sort field by date mm/dd/yyyy

Hello Group, I would like to sort the below file by date (first year then month and day) and I used the following command but it does not work sort -n -t"/" -k3 -k1 -k2 "sample original file" 12/28/2009,1.0353 12/31/2009,1.0357 12/30/2009,1.0364 12/29/2009,1.0366 12/24/2009,1.0386... (6 Replies)
Discussion started by: csierra
6 Replies

9. Shell Programming and Scripting

converting the date field from dd/mm/yyyy to yyyy/mm/dd

How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix my script will generate text file which have two fields one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will... (4 Replies)
Discussion started by: pareshan
4 Replies

10. Shell Programming and Scripting

Change Date from dd-mmm-yyyy to mm/dd/yyyy

I want to change a date from format dd-mmm-yyyy to mm/dd/yyyy. Is there a way to do this with sed or do you have to write a case statement to convert JAN to 01? Thanks (9 Replies)
Discussion started by: stringzz
9 Replies
Login or Register to Ask a Question