General

Re: Using TRANSLATE to force uppercase

Sailor — Tue, 13 Dec 2011 14:30:18 GMT

Hello, and thank you for your assistance. I guess I'm not 100% sure where the Translate function needs to go. This was what i had tried

translate(WorkZip[Company = Title], "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ")

This is a rule to set a fields value (VendorPostalCode) when the drop-down (Company) is equal to (Title) which is the Column in SP which has the company name.

The Main Data Source field to store the PostalCode is (VendorPostalCode) and the Secondary Data Source is (WorkZip)

Using the above rule does NOT populate the VendorPostalCode field.

EDIT - Stupid unrelated mistake on my part. This did work....I guess I DID actually know what I was doing. Thanks again for the time!

Re: Using TRANSLATE to force uppercase

ErnestoM — Tue, 13 Dec 2011 10:29:27 GMT

Hi-

The function is really the same. Instead of selecting a value to translate from the main data source, just select the node from the secondary data source. If you're using default values, then include the translate() function in the default value.

If you can explain what you've tried ,or attach an XSN via the Options tab, it might help to understand the issue. Thanks!

Using TRANSLATE to force uppercase

Sailor — Mon, 12 Dec 2011 15:07:17 GMT

Hello,

I am aware of how to use the translate function to convert a field to uppercase, but I'm not sure logistically how to do this for a value retrieved from a sharepoint list.

In my case I have a Postal Code value retreived from a SP list, into the main data source in a field "VendorPostalCode". The value in the SP list is not all upper case, so I want to convert it. What is the correct method for this? The "VendorPostalCode" is populated from a rule in a list box that selects the VendorName.

Thanks!