The Delimiter macro for Excel makes it easy to paste a list of values, or create grouped values, in BusinessObjects. The macro enables you to select a range of numbers within Excel (such as Project Grants, Vendor IDs, or EmplIDs) and copy the whole list into a query filter or prompt. By default, the Delimiter separates the values with semicolons, which is what BusinessObjects requires.
The macro can also create formulas for custom groupings of values in BusinessObjects using if-then-else logic.
Download the BusinessObjects Helpers Add-In for Excel 2013 and 2016
The delimiter macro is not supported by ITS. For problems or questions, please contact [email protected].