Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
BI Consultant