General discussion

Locked

Cleansing Data

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)

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

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; -----+

Collapse -

Cleansing Data

by awillenborg In reply to Cleansing Data

The question was auto-closed by TechRepublic

Collapse -

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

Collapse -

Cleansing Data

by awillenborg In reply to Cleansing Data

The question was auto-closed by TechRepublic

Collapse -

Cleansing Data

by awillenborg In reply to Cleansing Data

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Software Forums