Hi all,
Need help in Parsing out the Date in Date Format "YYYY-MM-DD" from the Full Path. It needs to be dynamic as the path can change.
Look into the Attached Sample below and please help out with a solution
@DataPirate26 One way of doing this, this formula also checks whether the date has "th" or "nd" or "st" based on that it applies the regex formula
Regex + Formula would suffice. Please adjust regex if it does not make sense to your real data.
@DataPirate26 one more solution to it , I have tried to keep it simple and understandable 😊