Extracting words from non unique table rows Tableau 2020.2.6

Question

I have a list of data in tableau with different total string count and different suffixes for example:

In tableau 2020.2.6 ... REGEXP_EXTRACT(string, "^([A-Z]+ )*[A-Z]+") does not work.

Thank you in advance for your tips.

Hello @AbdessabourMtk, Thank you for the reply but this doesn't do it. This basically grabs the last letter in every line. — sycythe_j, Nov 20 '20 at 14:03
Hi All, thank you for the help. @WiktorStribiżew, your solution got me on the right path. Since I only wanted city name so, I didn't want "EDU" selected as well, this modified version of your solution worked ... ^([A-Z]+(?: +[A-Z]+)* (?:^EDU)?) — sycythe_j, Nov 24 '20 at 04:24
That's a corrupt pattern. `'^([A-Z]+(?: +[A-Z]+)* (?:^EDU)?)'` is identical to `'^([A-Z]+(?: +[A-Z]+)* )'` — Wiktor Stribiżew, Nov 24 '20 at 08:59

Abdessabour Mtk · Answer 1 · 2020-11-20T15:57:09.847

-1

the following regular expression will match the city names

^(?:[A-Z][a-z]+ )*[A-Z][a-z]+

use it with REGEXP_EXTRACT(string, "^(?:[A-Z][a-z]+ )*[A-Z][a-z]+")

edited Nov 20 '20 at 15:57

answered Nov 20 '20 at 13:57

Abdessabour Mtk

Hello, @AbdessabourMtK ... I am using this REGEXP_EXTRACT([string], '([A-Z]+ )*[A-Z]+'), since the city are in all CAP's. My apologies for omission. For one word cities i get "null and for multi word cities it grabs the second word in the string. – sycythe_j Nov 20 '20 at 14:16
@sycythe_j can you update the question with accurate examples, also the null and the selecting of the second word is due to the way `REGEXP_EXTRACT` work. I'll look into the documentation and try to come up with a solution. – Abdessabour Mtk Nov 20 '20 at 15:09
@sycythe_j try the new answer. – Abdessabour Mtk Nov 20 '20 at 15:57

1 Answers1