Extract different Date formats from String

[jamesehunt]

Hi All,

I am trying to extract a date from a String. Unfortunatle the Date format differs.

Any Suggestions?

Much obliged

[wdchristensen]

Where is your date coming from?

regexp_like for Oracle / patindex for sql server

[Frank_Hartmann]

Please share the text data. a screenshot is not helpful!

[wdchristensen]

It would help to see the source table. You can use YEAR(TODAY()) to patch the missing year but it would be more reliable to patch the year from the timestamp from the date it was entered. 

[jamesehunt]

The data is coming from our source system which is an AS400.

[jamesehunt]

Please find attached an extract in excel

[miskinmaz]

You can use the keep char to remove all the text and keep only the numbers. The next step will be to use alt function to format date into one format.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunction...