topic Text left from last space in QlikView

Text left from last space

francisvandergr — Fri, 21 Oct 2011 08:56:17 GMT

I have a question. Is there a function to get a part of a field left from the last space in that field. For example

I have field "Name " with the following values:

van den Bergh

Jansen

van Achteren

van der Grijn

Pietersen

In this example i need the values :

van den

van

van der

How is this possible with QV?

Re: Text left from last space

Miguel_Angel_Baeyens — Fri, 21 Oct 2011 09:14:12 GMT

Hi Francis,

I'd use something like the following in the script

If(Index("Name ", ' ', -1), Left("Name ", Index("Name ", ' ', -1) -1), 'No Space') AS Req

That reads if there is a space in the current value of "Name " then return all characters from the left until the last space, if there is no space, return "No Space".

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica