Discussion Board for collaboration on QlikView Scripting.
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.
What does your string look like? Few possible sample strings?
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.
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
Sound good... unless we know the specific text, it might be difficult to give a generic solution which works for all scenarios
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?