C Handling Special Characters

Oracle Enterprise Performance Management Cloud passwords, proxy passwords, and command parameter values may contain special characters. Special handling is required for EPM Automate to handle such characters.

The examples in this section use a sample password to illustrate the use of special characters.

Oracle recommends that you enclose parameter and value pairs in double quotation marks.

Windows

These special characters must be escaped using double quotation marks (") around the special character or around the parameter value containing the special character.

Note:

EPM Automate cannot be run from a folder that contains & in its name; for example, C:\Oracle\A&B.

Table C-1 Special Character Handling: Windows

Character	Description	Escaped Example
)	Close parenthesis	Example")"pwd1 or "Example)pwd1"
<	Less than	Example"<"pwd1 or "Example<pwd1"
>	Greater than	Example">"pwd1 or "Example>pwd1"
&	Ampersand	Example"&"pwd1 or "Example&pwd1"
|	Pipe	Example"|"pwd1 or "Example|pwd1"
"	Quotation mark	Example"""pwd1 or "Example"pwd1"

Using Exclamation Mark in Plain Text Passwords in Windows Batch Files

Use of exclamation mark (!) in plain text passwords in Windows batch files used with EPM Automate should be handled as follows:

1. Use two caret symbols (^^) before the exclamation mark as the escape character. For example, if the password is Welc0me!, encode it as Welc0me^^!
2. Update the bach file to set DisableDelayedExpansion at the beginning of the file by including the following declaration:

   setlocal DisableDelayedExpansion

3. Remove setlocal EnableExtensions EnableDelayedExpansion declaration, if present, in the script.

UNIX/Linux

On UNIX and Linux operating systems, special characters must be escaped using a backslash (\).

Note:

• To escape ! (exclamation mark), use a single quotation mark around the password or use the back slash (\) as the escape character.
• To escape \, $, ', and ", use a double quotation mark around the password or use the back slash (\) as the escape character.

Table C-2 Special Character Handling: UNIX/Linux

Character	Description	Escaped Example
(	Open parenthesis	Example\(pwd1
)	Close parenthesis	Example\)pwd1
<	Less than	Example\<pwd1
>	Greater than	Example\>pwd1
`	Apostrophe	Example\'pwd1
!	exclamation mark	'Example!pwd1' or Example\!pwd1
#	Hash	Example\#pwd1
&	Ampersand	Example\&pwd1
|	Pipe	Example\|pwd1
;	Semicolon	Example\;pwd1
.	Period	Example\.pwd1
"	Quotation mark	Example\"pwd1 or "Example\"pwd1"
'	Single quotation mark	Example\'pwd1 or "Example\'pwd1"
$	Dollar sign	Example\$pwd1 or "Example\$pwd1"
\	Back slash	Example\\pwd1 or "Example\\pwd1"

Using Exclamation Mark in Plain Text Passwords in UNIX or Linux Scripts

In UNIX/Linux scripts, if an EPM Automate password stored in a shell variable contains special characters, use three back slashes as the escape sequence and then enclose the string in double quotation marks. For example, the password lzi[ACO(e*7Qd)jE included in the shell variable password should be scripted as follows:

password="lzi[ACO\\\(e*7Qd\\\)jE"