Date Extraction

arshi · Post by **arshi** » Wed May 21, 2008 5:28 am

Hi,

I am facing problem in the date extraction from source file.

Source File Format : File Name-21082008.xls

From this source file I need to extract 'Last day of the month' and populated into the Target column.

How to implement this.

Regards,
Arshi

Cr.Cezon · Post by **Cr.Cezon** » Wed May 21, 2008 6:07 am

with a routine

arshi · Post by **arshi** » Wed May 21, 2008 6:26 am

is there any other way?

Cr.Cezon · Post by **Cr.Cezon** » Wed May 21, 2008 6:33 am

you have transforms like MONTH.LAST already created by DS

ray.wurlod · Post by **ray.wurlod** » Wed May 21, 2008 3:44 pm

Code: Select all

MONTH.LAST(Iconv(DIGITS(#FileName#),"DDMY"))

arshi · Post by **arshi** » Fri May 23, 2008 2:33 am

Hi,

File Format: File Name-ddmmyyyy.csv

From this file how do I pass #FileName# in the below code

Code:
MONTH.LAST(Iconv(DIGITS(#FileName#),"DDMY")) .

Regards,
Arshi

ray.wurlod · Post by **ray.wurlod** » Fri May 23, 2008 6:04 am

Without the "#" characters. Use the expression editor to build the expression, particularly to add the job parameter name, to see what I mean.

arshi · Post by **arshi** » Mon May 26, 2008 10:09 pm

Hi Ray,

Can you please explain it.I am unable to understand.

Regards,
ARSHI

ray.wurlod · Post by **ray.wurlod** » Mon May 26, 2008 10:14 pm

The file name is a job parameter. Build an expression that applies the DIGITS transform to this job parameter. Use the expression editor to construct the expression, so that correct syntax is guaranteed.