How can this be solved in a data module?

A developer has a source system provided by another company. One of the columns in a table has spaces before each piece of data and is in uppercase which makes the reports unreadable .

How can this be solved in a data module?
A . there is no built in capability for this in a data module and the developer needs to create a calculation for this
B . there is no built in capability for this in a data module and the report needs Trim and Lower calculations added to it
C . using the ‘Clean’ menu item on the data item
D . using the ‘Prepare’ menu item on the data item

View Answer

Answer: A