Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Decode a base 64 encoded string and convert to ASCII using a PowerCenter mapping
Solution
A base 64 encoded string can be decoded by using the PowerCenter DEC_BASE64 function in an expression.
 
The output of the DEC_BASE64 function is a binary value which can then be fed to a Java transformation and translated back to ASCII using standard Java string functions.
The attached workflow contains a sample mapping and workflow (for version 8.6.1)
 
The mapping decodes the base 64 representation of the string "This is a test string", and translates the decoded output from binary to string format. Any input file can be used to run the session.
 
The base 64 representation of "This is a test string" is VGhpcyBpcyBhIHRlc3Qgc3RyaW5n. You can use a converter tool such as the one on http://www.hcidata.info/base64.htm to get the base 64 representation for any string.
 
 
 
 
 
 
More Information
Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 8.6; PowerCenter 9.x
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:8/8/2011 2:39 AMID:32298
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)