Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Subfield issue

Hi,

Consider the following data:

WWW

google.com

bing.com

facebook.com

google.de
google.fr
google.co.uk
google.es
bing.it
google.ca
bing.nl
google.se
google.pl

How do I get the domain ? In fact I want the resulting field to return:

DOMAIN

.com

.de

.fr

.uk

.es

.it

.ca

.nl

.se

.pl

How to accomplish that in the script using for instance subfield ?

Thanks,

David

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

subfield(WWW, '.', -1)

-Rob

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

subfield(WWW, '.', -1)

-Rob

Anonymous
Not applicable
Author

Hi Mr. Wunderlich,

Thanks for the reply - such a simple solution 🙂

BR,

David

Anonymous
Not applicable
Author

Hi again Mr. Wunderlich,

Sorry to bother you but could you please have a look at my post regarding Google Static World Heat Map. I believe you have some good input - since the original post of the app was made by you way back in the days + plus you had some good examples in your cookbook (regarding Google static map API) which I can't find right now.

Google Static map sorting issue

Highly appreciated!

Thanks,

David