Convert a string to Upper case David Paras December 19, 2013 17:47 Updated How can I convert a string to Upper case in the mapper? Related articles Connecting to MQ Error processing Excel file Day of Week in the Data Mapper Using DateUtils method Title Case Function Comments 1 comment Sort by Date Votes David Paras December 19, 2013 16:16 In the data mapper, under string function there is a translate option. It can translate lower case to upper or vice versa. For example, if you would like to convert AdePtiA into all upper case, then the rule would be translate( 'AdePtiA' , 'abcdefghijklmnopqrstuvwxyz' , 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' ) 0 Article is closed for comments.
Comments
1 comment
In the data mapper, under string function there is a translate option. It can translate lower case to upper or vice versa.
For example, if you would like to convert AdePtiA into all upper case, then the rule would be
Article is closed for comments.