Text left from last space

[francisvandergr]

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?

[Miguel_Angel_Baeyens]

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