Name
1
JS_KEYWORD
2
json_tokens
3
DMS_tokens
Drag to adjust the number of frozen columns
Source
Docs
Compiled
Type
groupName
\b(?:await|break|case|catch|class|const|continue|debugger|default|delete|do|else|enum|export|extends|false|finally|for|function|if|implements|import|in|instanceof|interface|let|new|null|package|private|protected|public|return|super|switch|static|this|throw|try|True|typeof|var|void|while|with|yield)\b
(?P<reckLMi6yYRcLqPHC>\b(?:await|break|case|catch|class|const|continue|debugger|default|delete|do|else|enum|export|extends|false|finally|for|function|if|implements|import|in|instanceof|interface|let|new|null|package|private|protected|public|return|super|switch|static|this|throw|try|True|typeof|var|void|while|with|yield)\b)
Named Group
(\[)|(\])|(\{)|(\})|(\:)|(,)|(-)|(null)\b|(true)\b|(false)\b|(\d+(?:\.\d+)?(?:e[-+]?\d+)?)|(\"(:\\\"|[^\"])*\")|(?P<values>[^\[\]{}:,\"\s]+)


Replacement Map

$1$2$3$4$5$6$7$8$9$10$11$12$13$<values>

(?:(\[)|(\])|(\{)|(\})|(\:)|(,)|(-)|(null)\b|(true)\b|(false)\b|(\d+(?:\.\d+)?(?:e[-+]?\d+)?)|(\"(:\"|[^\"])*\")|(?P<values>[^\[\]{}:,\"\s]+))
Non-Capturing Group
index
id
name
(?P<DMS>
  (
    (?P<latitude>
      (?P<lat_degrees>\d+([.]\d+)?)[°]\s*
      (?P<lat_minutes>\d+([.]\d+)?)[’\']\s*
      (?P<lat_seconds>\d+([.]\d+)?)["]\s*

A pattern for tokenizing geopositional data pairings in the degrees-minutes-seconds format.


💬 Approach

We'll use this regex to **tokenize all DMS data in a given text field**. The assumption being each cell contains only one latitude-longitude pair. Otherwise, only the last pair will be used. Google says the DMS convention is to write longitude before latitude, but this pattern won't care about the order. Any other preceding or subsequent characters are ignored, so this expression also standardizes your data while it's at it.


⚠️ One or two fields?
(?P<DMS>((?P<latitude>(?P<lat_degrees>\d+([.]\d+)?)[°]\s*(?P<lat_minutes>\d+([.]\d+)?)[’\']\s*(?P<lat_seconds>\d+([.]\d+)?)["]\s*(?P<lat_line>(?i)N|(?P<lat_negative>S)))|(?P<longitude>(?P<lon_degrees>\d+([.]\d+)?)[°]\s*(?P<lon_minutes>\d+([.]\d+)?)[’\']\s*(?P<lon_seconds>\d+([.]\d+)?)["]\s*(?P<lon_line>(?i)E|(?P<lon_negative>W))))|\s+){1,}|(?s).+
3 records
Extensions

Alert

Lorem ipsum
Okay