2 Replies Latest reply on May 25, 2016 7:25 AM by Mark ODonnell

Display last time a string appears in text.

Mark ODonnell May 24, 2016 12:53 PM

I am trying to parse some hashtags in a text field and use them as column names and colors.

If I have #hash1 #hash2 #hash3 included in a single data field my calculation will display #hash3 correctly.

If I have #hash1 #hash2 #hash3 #hash1 #hash3 I want it to display #hash3.

The hashtags are contained in a history field which contains much more text than just the hashtags.

My calc needs to first find all the hashtags and somehow determine which one is displayed last.

I've tried counting them, finding them, but I am at the point where I could use some guidance. I am trying to avoid lengthy statements that will need clever maintenance if/when new hashtags are used.

Thanks in advance.

1. Re: Trying to find or count number of times a string appears.

Ivan Young May 24, 2016 12:55 PM (in response to Mark ODonnell)

Hi Mark,
You should be able to use RegexpMatch which returns Boolean along with Sum to achieve your result.

Good luck,
Ivan
Like Show 0 Likes(0)

Actions
2. Re: Display last time a string appears in text.

Mark ODonnell May 25, 2016 7:25 AM (in response to Ivan Young)

I think this put me on the right track. I had to do some research but believe that REGEXP_EXTRACT_NTH 'should' work.
I have tested this regex with a few tools and it appears to be valid but using it in Tableau returns null values.

REGEXP_EXTRACT_NTH([DValue],'(#*)#.*',-1)
What I think this should do is find the last value of a string which starts with '#' in my dimension.
But when used in Tableau I get NULL values.
IF REGEXP_EXTRACT_NTH([DValue],'(#*)#.*',-1) = '#hash2' then 'TEXT VALUE'

Any ideas? Thanks...
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Display last time a string appears in text.

1. Re: Trying to find or count number of times a string appears.

2. Re: Display last time a string appears in text.

Actions

More Like This