Topic: Alphabet case conversion

Topic by
datacleanuser123

2011-04-12
15:49

Alphabet case conversion

Is there a feature for Alphabet case conversion in DataCleaner tool.

Reply by
kasper

2011-04-12
16:18

Not specifically, but you could rather easily use the Javascript transformer for that... In Javascript strings have toUpperCase() and toLowerCase() methods you can apply like this:

var upper = myString.toUpperCase();

Reply by
datacleanuser123

2011-04-12
18:08

It worked fine. I did like this

function eval() {
  //return "hello " + values[0];
var upper = Name.toUpperCase();
return upper;
}

eval();

Reply by
wsquare

2011-09-16
05:23

Hi,

I'm a new user of Datacleaner, and am exploring normalizing & cleaning my set of data.

Was trying to find a way to capitalize all my text, and came to this post in forum..

I did the exact same code input, and ran into an error when I preview output

Error as follow:
ReferenceError: "Name" is not defined. (JavaScriptTransformer#4)

I only selected a data field say 'Course Name' . How should i go about declaring the var to use the data in the corresponding field?

A pity there is no documentation on how to use this, as i believe this function coupled with javascript will give a lot more features that current software can provide. I'm just a beginner in javascript as well.. btw..

Thanks again for any help!

Reply by
kasper

2011-09-16
05:23

For reference, the reply to wsquare's enquiry is available here: http://datacleaner.eobjects.org/topic/239/Javascript-Help-for-Case-Conversion

Log in by clicking the login link at the top of the screen

Topic: Alphabet case conversion

Alphabet case conversion

You need to be logged in to participate