Answers.Body: <p>You can connect to USPS Web Tools which will do this standardization. Go to administer > localization > address settings. Signup <a href="https://www.usps.com/business/web-tools-apis/welcome.htm" rel="nofollow noreferrer">https://www.usps.com/business/web-tools-apis/welcome.htm</a> and you can get it working right away. That will take care of when create / update happen.</p>
  
  <p>For existing records you can use <a href="https://civicrm.org/extensions/cividesk-normalize" rel="nofollow noreferrer">Cividesk Normalize</a> and it allows you to perform normalization based on a contact ID range: <a href="https://civicrm.org/extensions/cividesk-normalize" rel="nofollow noreferrer">https://civicrm.org/extensions/cividesk-normalize</a>.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-09-09T10:37:13.740Z
Answers.Text: Hello Andy. Thank you for your answer. You give me hope! Jokes apart: I'm trying to enable USPS Web Tools. I've registered and entered the ID they gave me and the URL (both http://production.shippingapis.com/ShippingAPI.dll and https://secure.shippingapis.com/ShippingAPI.dll). But nothing happens. If I create a new contact with a bad formatted address...nothing happens and the bad address saves. What am I missing? I've tried both production URLs
Answers.UserDisplayName: Marco
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-09-07T04:11:29.310Z
Answers.LastActivityDate: 2019-09-07T14:12:22.517Z
Answers.LastEditDate: 2019-09-07T14:12:22.517Z
Answers.UserDisplayName: Andy Burns
Answers.Body: <p>I don't think that is possible out of the box, but it would be an easy extension to write.  You could use <a href="https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_pre/" rel="nofollow noreferrer"><code>hook_civicrm_pre</code></a>, look for edit/create operations on Addresses and change the relevant fields to uppercase.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-09-06T07:14:12.877Z
Answers.LastActivityDate: 2019-09-06T07:14:12.877Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>You may use CSS. 
    <strong>text-transform: uppercase;</strong></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-09-07T13:12:49.663Z
Answers.Text: That would work when viewing the contact summary page but it sounds like Marco needs it stored in the database as uppercase or at least stored in postal-friendly format.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-09-07T09:49:29.027Z
Answers.LastActivityDate: 2019-09-07T09:49:29.027Z
Answers.UserDisplayName: Abdul Samad
Body: <p>Is it possible to convert every letters in a specific field to uppercase?</p>
  
  <p>I would like to have the addresses of my contacts on Civi written in uppercase (for postal service purposes).</p>
  
  <p>The ideal scenario would be to force that field to be uppercase. But also converting it after the record is created would be sufficient.</p>
  
  <p>Thank you.</p>
  
Tags: <contacts>
Title: Convert to uppercase all letters in a specific field
ThreadText: # Convert to uppercase all letters in a specific field
  
  (Asked by: username_0 on 2019-09-06)
  
  Is it possible to convert every letters in a specific field to uppercase?
  
  I would like to have the addresses of my contacts on Civi written in uppercase (for postal service purposes).
  
  The ideal scenario would be to force that field to be uppercase. But also converting it after the record is created would be sufficient.
  
  Thank you.
  
  **Tags:** contacts
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2019-09-07. Score: 2
  
  You can connect to USPS Web Tools which will do this standardization. Go to administer > localization > address settings. Signup <https://www.usps.com/business/web-tools-apis/welcome.htm> and you can get it working right away. That will take care of when create / update happen.
  
  For existing records you can use [Cividesk Normalize](https://civicrm.org/extensions/cividesk-normalize) and it allows you to perform normalization based on a contact ID range: <https://civicrm.org/extensions/cividesk-normalize>.
  
  > **Comments:**
  > **username_0**: Hello username_1. Thank you for your answer. You give me hope! Jokes apart: I'm trying to enable USPS Web Tools. I've registered and entered the ID they gave me and the URL (both http://production.shippingapis.com/ShippingAPI.dll and https://secure.shippingapis.com/ShippingAPI.dll). But nothing happens. If I create a new contact with a bad formatted address...nothing happens and the bad address saves. What am I missing? I've tried both production URLs  
  
  ---
  
  ### Answer by username_2 on 2019-09-06. Score: 2
  
  I don't think that is possible out of the box, but it would be an easy extension to write. You could use [`hook_civicrm_pre`](https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_pre/), look for edit/create operations on Addresses and change the relevant fields to uppercase.
  
  
  ---
  
  ### Answer by username_3 on 2019-09-07. Score: 0
  
  You may use CSS.
    **text-transform: uppercase;**
  
  > **Comments:**
  > **username_4**: That would work when viewing the contact summary page but it sounds like username_0 needs it stored in the database as uppercase or at least stored in postal-friendly format.  
  
  ---
  
  