Adam Cooke

I currently work as a consultant for Qlik, a software company doing some interesting stuff in business intelligence. Check it out I write this blog to showcase some technical bits that I hope will be useful to others.


string functions Tag

Webofwork > Posts tagged "string functions"

Subfield() is a great function for splitting a long string into seperate fields. You can use this to split out a date or anything where you have a common delimeter in a string. For example. If you have the string field name: TextString line 1: Big_Frogs_Are_Yummy You may want to split this out into 4 seperate fields. subfield(TextString, '_', 1) as FirstWord, subfield(TextString, '_', 2) as SecondWord, subfield(TextString, '_', 3) as ThirdWord, In...

Read More