Extract SQL statements within within an EPM code snippet...

How to use

To use this tool, paste your EPM snippet with the SQL in the code and press the 'Decode EPM' button. This will remove all the formatting and other EPM code around the SQL statement.

If your snippet has more than one SQL statement in the code, then populate the string variable field with the name of the string variable; this will instruct the Decode process to pick a specific SQL statement.

The Input

The Output

Click the Decode button above and your SQL will be printed below