Date Fetch

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Date Fetch

fvelascog72 — Tue, 13 Mar 2018 09:25:18 GMT

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.