Webi String Question - Easy I Think

[Edie0802]

I am very new to Webi. I am using BOXIR2.

I have a column of data that has (last name, first name), for example:

Brown, Susan
Googlemeyer, Bob

I only want to display what is left of the comma:

Brown
Googlemeyer

How do I write a formula (function) on that data element that will accomplish this?

Thanks.

 

[hilfy]

You may have to tweak this a little, but you'll do something like this:

=left(dimension, (pos(dimension, ",") -1))

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.