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 |
|
< |
Less than |
|
> |
Greater than |
|
& |
Ampersand |
|
| |
Pipe |
|
" |
Quotation mark |
|
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:
- Use two caret symbols (^^) before the exclamation mark as the escape character. For example, if the password is
Welc0me!
, encode it asWelc0me^^!
- Update the bach file to set DisableDelayedExpansion at the beginning of the file by including the following declaration:
setlocal DisableDelayedExpansion
- 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 |
|
# |
Hash | Example\#pwd1 |
& |
Ampersand | Example\&pwd1 |
| |
Pipe | Example\|pwd1 |
; |
Semicolon | Example\;pwd1 |
. |
Period | Example\.pwd1 |
" |
Quotation mark |
|
' |
Single quotation mark |
|
$ |
Dollar sign |
|
\ |
Back slash |
|
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 passwordlzi[ACO(e*7Qd)jE
included in the shell variable password
should be scripted as follows:
password="lzi[ACO\\\(e*7Qd\\\)jE"