Hello, I'm using a string searcher to find "Dates" out of a "Comments" field. I have a column of all matches (Screen shot attached). How can i extract the most recent date out of all matches? Probably would help if I change "/" to another symbo
Best answer by markatsafe
@egeiser You can match the dates with the regex: (\\d{1,2}/\\d{1,2}/\\d{1,2}) in the StringSearcher. Under Advanced, add an All Matches List Name: _allDates. If the last date in the pattern is always your recent date then you can just use ListIndex with List Index to Copy: -1
If the last date in the list isn't the most recent, then you'll have to explode the list, Use DateTimeConverter to make the date an FME date and then pick out the most recent from there
@egeiser You can match the dates with the regex: (\\d{1,2}/\\d{1,2}/\\d{1,2}) in the StringSearcher. Under Advanced, add an All Matches List Name: _allDates. If the last date in the pattern is always your recent date then you can just use ListIndex with List Index to Copy: -1
If the last date in the list isn't the most recent, then you'll have to explode the list, Use DateTimeConverter to make the date an FME date and then pick out the most recent from there
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.