Date Fetch

[subbareddykm]

Hi All ,

can anyone ease tell the how to fetch the date from unstructured format data.

I tried it in many function like mid , replace date and all but no luck.

Could anyone please tell me the logic to get the date using ref file.

[fvelascog72 · Accepted solution]

Hi,

Try with:

DATA:

LOAD

     Right(DATE,4)& Left(DATE,2)           as YearMonth,

     [Date Format];

LOAD

     Right(KeepChar([Date Format], '1,2,3,4,5,6,7,8,9,0'),6) as "DATE",

     [Date Format]

FROM

[Date.xlsx]

(ooxml, embedded labels, table is Document_LB44);

Saludos.