2 Replies Latest reply: Oct 3, 2014 4:17 AM by Michiel van de Goor RSS

    Normalizing Upper and Lower characters of fields after loading data

    Nick LOumakis

      Hi,

       

      I'm loading "County" from an excel file but the fields are either in UPPER or lower case (e.g. GREECE and greece) so they show as different countries in my app.

       

      How do I normalize the fields after I've loaded data, without having to fix the source data?

       

      thanks/n