topic Extract date from notes in QlikView

Extract date from notes

anjali0108 — Thu, 25 May 2017 11:10:41 GMT

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.

Re: Extract date from notes

sunny_talwar — Thu, 25 May 2017 11:13:53 GMT

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

Re: Extract date from notes

anjali0108 — Thu, 25 May 2017 11:19:31 GMT

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.

Re: Extract date from notes

Sergey_Shuklin — Thu, 25 May 2017 11:29:48 GMT

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

Re: Extract date from notes

sunny_talwar — Thu, 25 May 2017 11:41:57 GMT

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

Re: Extract date from notes

Sergey_Shuklin — Thu, 25 May 2017 12:23:31 GMT

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?