spliting string field into two variables

[sbrunswik]

Using CR10 with MYSQL, need to split a sting to create variables to do search on.
string is {lastname, firstname} table that I need to search has seperate field for each value. I tried using
Split ({lastname,firstname}, ",") but get an error message the result of a formail can not be an array

Thanks for any help

 

[vidru]

You'll need two separate formulas, and each has to be setup to get a subscript of the resulting array:

//@LastName
If InStr({lastname,firstname}, ",") > 0 Then
Split ({lastname,firstname}, ",")[1]
Else
{lastname,firstname};

//@FirstName
If InStr({lastname,firstname}, ",") > 0 Then
Split ({lastname,firstname}, ",")[2]
Else
"";

I included some error checking, in case you have some data in your {lastname,firstname} field that's incomplete. My example would assume that a Last Name was entered if there isn't a comma in the field.

-dave

 

[sbrunswik]

Thanks for the help, If I need to Trim on the returned values, do I need to create a seperate formula?

-sonora

 

[vidru]

No, you can just wrap the Split() part in the Trim function:

Trim(Split({field}, ",")[1])

-dave