Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
Hi, You can use Function Capitalize(Fildname) also you can use Upper() to make field in Upper case . Hope this help.
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?
Please use in Script
i would prefer in script, then its done only once and not each time when you openthe listbox
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?
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