VB script question - SelectValues

[joefeyas]

Is there away to make the field selection NOT be case-sensitive?

ActiveDocument.Fields("SomeField").SelectValues  MyValues()

[ToniKautto]

Why not use the triggered action Selection > Select in Field instead of doing it from a macro?

[joefeyas]

The user is inputing a comma delimited list (usually copied from an email etc) into an input box and selecting a field to search on.

Many cases its a numeric field like cust_id so, but in the case of something like CITY if the user enters them as:  trenton, new york, seattle

The selection will fail to find  "Trenton" "New York"  "SEATTLE" etc...

[joefeyas]

I tried a Select In Field action setting search string to an expression based on = 'MixMatch ... and it seems to work!   (Theres a few hundred fields to test in the data model so I'm still a ways from declaring total victory)

However, I'd still like to see if there is way to fix the issue using the API. If anyone has any ideas, please post.

[rwunderlich · Accepted solution]

I believe you can use search strings in the API. Just use Select and ToggleSelect instead of SelectValues.

-Rob

[joefeyas]

I modified my macro to use ToggleSelect and that worked.   (Search input was '3m usa' and it found both '3M USA' and '3M Usa')

Now to see how well it scales up to 500 inputs at once...  Unfortunatly the mixmatch method described above crashed the server when I tried to scale it, although it works great for < 10 search values.

Thanks 🙂

[#7]

Hi joefeyas,

Can you provide the end example of what you found to work using toggle select with user input? I am interested in allowing users to input a list of style numbers to select at one time, and this sounds like it could help.

Thanks!

Tyler