Uploading excel spreadsheets and displaying data values

[Anonymous]

Hi, I've uploaded (so far) 2 excel spreadsheets and the data files contain the same set of columns.  I've added a list box and it displays some of the values twice because one of the values is not capitalized.  How do I make it the same?  For example, one spreadsheet uses "In Progress" and the other spreadsheet uses "In progress."  I want it to know it means the same thing.  I'm sure I'll run into this as I keep loading more excel spreadsheets.

Thank you.

[Anonymous]

you can use uppercase(yourfield) or lowercase(yourfield), whatever you prefer for upper case or lower case characters

then all your data will look like this

is it what you want?

[vijay_iitkgp]

Hi, You can use Function Capitalize(Fildname) also you can use Upper() to make field in Upper case . Hope this help.

[Anonymous]

Yes Rudolf.  Thanks guys. Sorry I'm still new to this, but is the function added in the script in the load or in the list box properties?

[vijay_iitkgp]

Please use in Script

[Anonymous]

i would prefer in script, then its done only once and not each time when you openthe listbox

[Anonymous]

what if there were values such as Planning and Planning (xyz)? How do I upload the column and then add something that anything that starts with Planning really  means Planning?

[Anonymous]

there are several string functions which you can use

it depends what identifies your values

in your example it could be the string before the first space

you need to find something common for all values

or if there are only a few values you can build an inline table where you define your values

Test:

Load * Inline [

Val1, Val2

Plan, Planning

Plan, Planning (xyz)

]

and you do a left join to get the unique identifier

I would not suggest this way as it might be much work