I've received files with date inside. Now I want update parser to automatically determine the date.
I have two question:
- How load date from line? I suppose, first I should determine row with date and them drop 'Data as of:'
- On picture below date is '3/1/2015', but this was Sunday and I need to load this data as 'Last Saturday'. Is there any function, that can automatically change date to last Saturday( for example 3/1/2015 - > 2/28/2015)