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 ;
3. Copy the string from the second text box and paste it into the Business Object prompt window.