Replacement formula

[ImArchimedes]

Having trouble with the output for one field. The table field {Trip.School} stores a number of school codes, usually one or two. The output for this field is odd though. Say there is only one school associated with this trip, the output for that school, say it was "RHS", would be "RHS!". If there where 2 schools associated with the trip, "RHS" and "BES", then the field output would be "RHS!BES!"

Is there some way to formulaicly replace "!" with ", " so the output for that above example would be "RHS, BES"? Anyone know. I know this is an odd one. Thank you in advance for any help you can give.

 

[ImArchimedes]

Lol, nm. I actually just found it. Sorry everyone. Ignore this

 

[lbass]

Try this:

stringvar x := replace({table.code},"!",", ");
if instr({table.code},"!") <> 0 then
left(x,len(x)-2) else
{table.code}

-LB

 

[ImArchimedes]

What does that last part do, starting with
"if instr({table.code},"!") <> 0 then
left(x,len(x)-2) else
{table.code}

 

[lbass]

It trims off the final comma and space, and also checks to see whether the code contains the !, and if it doesn't it returns the field itself--just in case there are some variations.

-LB

 

[ImArchimedes]

Wow, excellent. I'm going to scrounge around and see if I can understand the logic of the formula but this will be great. Thank you again.