Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

anjali0108
Contributor II

Extract date from notes

Hi all,

I have a string field(notes) that has dates in it.

I want to extract the dates or max date from it for further calculations.

How can I do that?

Thanks in advance.

5 Replies
MVP
MVP

Re: Extract date from notes

What does your string look like? Few possible sample strings?

Highlighted
anjali0108
Contributor II

Re: Extract date from notes

Hi sunny,

Actually,I myself did not receive the data yet but got the requirement so wanted to know if its feasible.

Will share sample data asap once I get it from the account team.

Thanks.

serj_shu
Valued Contributor

Re: Extract date from notes

Hello, Anjali!

If your string consist of some separators which are enclose the date you can use some string function for exctracting the date:

TextBetween - if your date like <01.01.2017>

Subfield - if you have specified separator

KeepChar - if your date is a number 48523 and there is no other numbers in a string

MVP
MVP

Re: Extract date from notes

Sound good... unless we know the specific text, it might be difficult to give a generic solution which works for all scenarios

serj_shu
Valued Contributor

Re: Extract date from notes

Yeah, it's quite interesting to speculate, but w/o samples it worth nothing =D ... Maybe there is a hint or a clue how possibly the string may looks like?

Community Browser