You are not logged in.
I got a set of data which the string is uppercase. How can I make the the data downcase except for the 1st alphabet? I know in tMap got function called downcase but it actually convert all the string to downcase.
For example, I got a data from source table as below:
2012.0 4 2012-04-15 00:00:00 ONE-OFF MODULE 30000 3
And I want to change the data to:
2012.0 4 2012-04-15 00:00:00 One-off Module 30000 3
Last edited by mfuzaimi (2012-06-13 10:42:02)