Jump to content

List elements with '+' character


christianv

This topic is 7543 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi everyone,

Big one for you here! smile.gif

I have a file 'results' with four records in wich I have a field 'ResultName'. Here are the four ResultName values:

1- A

2- A+

3- B

4- B+

In another file, I want to display a list of possible results, but the '+' in some 'ResultName' seems to mix up the list and I have only 2 choice instead of 4...(A and :

Can anyone help me?

Link to comment
Share on other sites

Not only does your related value list refuse to acknowledge A and A+ as separate values, but any relations and lookups based on those values, once you enter them, will not distinguish them.

Of course, manually setting a value list to offer those four values is no big deal, and the value list does show up properly if manually configured. Yet if you want to *do* anything with those values, like look up percentages or colors, they won't work well...

However, a calculation can properly treat A+ and A differently:

Case(value="A+",99,value="A",95,value="B+",89,85)

So, if you manually configure your value list, then you can get another field to display a corresponding number, and do all relations (etc.) on the basis of the number rather than the mis-parsed text string.

-ESpringer

Link to comment
Share on other sites

Something I discovered recently: setting indexing to ACSII has the side effect of making all find in that field case SENSITIVE. So a search for "dr" will not find "Dr" or DR" any more.

Link to comment
Share on other sites

This topic is 7543 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.