I have the following string in an attribute: "Jan 1 1960; Jan 1 1900; Jan 1 1960; 01/05/1890; Jan 1 1960; Jan 1 1960; Jan 1 1960; Jan 1 1960; Jan 1 1960; Jan 1 1960; " I need to extract the earliest year from the attribute, since this is input from a reader the attribute will have different values, but the year will always be in a 4 digit format. I want to use a regular expression to extract the earliest year, in this case it would be 1890. Is this possible?
Solved
Regular Expression to extract the earliest year from Attribute
Best answer by david_r
Here's one way:
- StringSearcher with a regex like "\\d{4}" to extract all occurrences of 4 consecutive digits. Specify a list name for all the "All matches list name"
- ListSorter in ascending numerical order on the match list
- ListIndexer on item 0 to extract the lowest number
Example:
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 8394 replies
- Best Answer
Here's one way:
- StringSearcher with a regex like "\\d{4}" to extract all occurrences of 4 consecutive digits. Specify a list name for all the "All matches list name"
- ListSorter in ascending numerical order on the match list
- ListIndexer on item 0 to extract the lowest number
Example:
Here's one way:
- StringSearcher with a regex like "\\d{4}" to extract all occurrences of 4 consecutive digits. Specify a list name for all the "All matches list name"
- ListSorter in ascending numerical order on the match list
- ListIndexer on item 0 to extract the lowest number
Example:
+44- Influencer
- 3434 replies
Thanks for your answer David. I'm Using FME 2016, the ListSorter transformer doesn't have the defined list in StringSearcher available.
Here's one way:
- StringSearcher with a regex like "\\d{4}" to extract all occurrences of 4 consecutive digits. Specify a list name for all the "All matches list name"
- ListSorter in ascending numerical order on the match list
- ListIndexer on item 0 to extract the lowest number
Example:
- 8394 replies
In FME 2016 I've used the Subexpression Matches List Name which makes the list available to the ListSorter
- 7843 replies
Just for fun. Sometimes FME can solve a puzzle with a collaborative work of string/math operations and geometric operations.
Set OGC Well Known Text to the Geometry Encoding parameter, and set this expression to the Geometry Source parameter in the GeometryReplacer
LINESTRING(@Trim(@ReplaceRegEx(;@Value(text),";.+?(?=\d{4})",",0 "),",; "))