General discussion

  • Creator
    Topic
  • #2080013

    Cleansing Data

    Locked

    by awillenborg ·

    I have a nightly feed coming from an Oracle Database. The data is all in caps and I would like to run a script which will reformat the data in a presentable format (upper and lower case). The fields include name, address, phone number.

    If someone has a list of all the exceptions I need to include in my script that would be helpful.
    (Example: DiNiro, Mary-Beth)

All Comments

  • Author
    Replies
    • #3903428

      Cleansing Data

      by rcavalca ·

      In reply to Cleansing Data

      Why don’t you use the character function initcap. This function will show
      all first to upper and others to lower.
      for example:
      JOHN SMITH ==> John Smith <----+ | select initcap(name) from tab; -----+

      • #3792772

        Cleansing Data

        by awillenborg ·

        In reply to Cleansing Data

        The question was auto-closed by TechRepublic

    • #3903360

      Cleansing Data

      by anurag ·

      In reply to Cleansing Data

      You can use the initcap() function. It will make the the first alpabet as capital and the rest as small in a word.
      For example ORACLE will be shown as Oracle.

      While queying you can use the function as
      select initcap(fieldname) from tablename;
      If field name is ORACLE it will be shown as Oracle.

      Anurag

      • #3792773

        Cleansing Data

        by awillenborg ·

        In reply to Cleansing Data

        The question was auto-closed by TechRepublic

    • #3792771

      Cleansing Data

      by awillenborg ·

      In reply to Cleansing Data

      This question was auto closed due to inactivity

Viewing 2 reply threads