Skip to main content

BI Prompt Converter

This utility is provided as a convenient way to convert lists of values into a string that can be copied into a Business Object's prompt. Often times values need to be copied from other sources (email, excel, etc…) into a Business Object prompt. The issue often arises that the required “;” (semi-colon) is not present in lists and thus will not provide the expected results in Business Objects without manually entering the semi-colons throughout the list of values. This tool was created to make that process easier.

To use the tool:
1.   Copy the list (vertical list) of values into the first text box below.
2.  Click ‘Convert’ to translate the vertical list of values into a string separated
by ;s.
3.  Copy the string from the second text box and paste it into the Business Object prompt window.