How to extract the date from text+date?

[laumartinezb]

Hello all,

I'm learning to use Qlik Sense and trying to build my first app. 

I was trying to get the date from a field that looks like this:

Resolution notes

ETC: 29-MAR-2020

I would like to extract the date, how should I do it having "ETC: " before the date?

Thank you very much in advance.

[agigliotti]

maybe this in script:

date#(mid([Resolution notes],6), 'DD-MMM-YYYY') as newdata

I hope it helps.

[Taoufiq_Zarra · Accepted solution]

attached

Date#(PurgeChar("Resolution notes",'ETC: '),'DD-MMM-YYYY') as New_Resolution,

[laumartinezb]

Thank you Taoufiq! One more question, if I have more text after the date, how should I exclude it in order to have only the date?

Example:

ETC: 14-Dec-2018
Implement OSS Note 2653389-False change of items in Check Cash Flow Item App

I would like to extract only 14-Dec-2018.

Thank you very much in advance!

Laura

[Taoufiq_Zarra]

Maye be

Date#(PurgeChar(left("Resolution notes",16),'ETC: '),'DD-MMM-YYYY')