Skip Navigation
Export character limit per field
Answer ID 4674   |   Last Review Date 11/14/2018

Does Oracle B2C Service Analytics have an option to limit to the number of characters per field that can be exported?


Oracle B2C Service


Oracle B2C Service Analytics has a text length option for text fields that can be edited within the column format options. The text length defines the limit to the length of text strings appearing in the column. Text strings that exceed the limit will be truncated.

You can edit the text length for a text column on a report by:

1. Open the report in edit mode
2. Right click on the column you wish to extend the text limit for.
3. Select "Edit Format"
4. Click the Text Tab
5. Edit the "Limit text to" field located under the "Text length" section
6. Click OK

Note: If you do not want to limit text length then select the radio button "Do not limit text length". The column is automatically resized to fit the length of the output text. This option is available only for VARCHAR columns. It is not available for memo(blob) and menu type columns.Please note however, that this should be used with some discretion and best practice is to limit your data sets to only what is necessary. Large data sets that are unlimited (or even set to very high values) could encounter memory problems due to Windows constraints and will not be exported.

To display the entire contents of the text field when running a report you will need to make sure the Wrap Text option is selected. Selecting the wrap text column will allow data to wrap to a new line if it exceeds the width of the column.

You can select wrap text by:

1. Open the report in edit mode
2. Right click on the column you wish to wrap text for.
3. Select "Edit Format"
4. Click the Alignment Tab
5. Select "Wrap Text" field and set "Limit Wrapped Text to x Rows" located under the "Data" section
6. Click OK

For additional information, refer to the 'Editing column format options' section in the Online Help User Guide documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.