Field with hyphens

[evansabres]

Hello -

I have a field that appears in this manner, name of the field is [Campaign Name] : (The field is an xlsx file)

NAME - 07032015 - TITLE

I also have an inline table:

tbl_CAMPAIGNS:
LOAD * INLINE
[ cmpNID, cmpCAT
1, BRAVES
2, KNIGHTS
3, JACKETS
4, HHH
5, CLUB
6, COM
7, SURVEY
8, HC ];

In my script, I am using:

UPPER(TRIM(SubField([Campaign Name], '-', 1))) AS cmpCAT, 

Also:

UPPER(TRIM(SubField([Campaign Name], '-', 2))) AS cmpNME,

This allows me to link the two tables so that I can have a list box from which to select the cmpCAT (Campaign Category)

The script runs with no issue and produces the list box in the manner I desire. However, when I click on a cmpCAT from the list box, my app does not produce any results.

Does my issue live in my scripting or is this a result of using an xlsx file?

Thank you.

[maximiliano_vel]

Could you post some sample of the xlsx and expected results?

[awhitfield]

Hi Evan,

can you upload your qvw and excel sheet?

Andy

[evansabres]

Thank you for your time in replying. I made a silly mistake in my data, my scripting was spot-on for what I was trying to do.

[evansabres · Accepted solution]

Thank you for your time in replying. I made a silly mistake in my data, my scripting was spot-on for what I was trying to do.