In many cases, you can put a simple expression into a date folder to capture dates included in item text:
get_contain_date() but that doesn't work so well with 'special cases' (such as Paypal transaction lists),
and, that doesn't help us understand how to TAKE CONTROL OF THE SLANG RULES.
so...
here are two simple functions that I use,
and a brief tutorial about what's going on.
Quote:++:+!:{3} + imatch("JAN01FEB02MAR03APR04MAY05JUN06JUL07AUG08SEP09OCT10NOV11DEC12",left({1},3
) + "(\d+)") + right("0" + {2},2):ITT ~= "^\s*([A-Za-z]+)\.?\s+(\d+),\s*(\d+)"
Quote:++:!+: replace({1},"(\d\d)/(\d\d)/(\d\d\d\d)","$3$1$2",1):ITT ~= "^[^\d]*([\d/]+)"
In the first example we use a
TABLE LOOKUP to convert a month (jan, january, etc.) to a numerica value 1-12.
that value is then sequenced after the year, and before the date (padded with 0).
In the second example, we grab the first instance of numbers slashes, and then use the replace function to change the order (and remove the slashes) to place in ecco 'date' format to be used in date folders.
Still confused ?
Ask, and your questions will be answered !