I am creating an export of a table to csv using the report metadata object. My requirement does not allow leading or trailing spaces. Will the report tool automatically trim leading and trailing spaces or do I need to do this in a logic block prior to exporting?
I think you’ll want to do this in a logic block. If you’re working with Report Builder, you can set the report to automatically generate a temporary dataset through a logic block (with the removal of leading/trailing spaces) for every report run and have it export that generated data to CSV.
OK, thanks. I was hoping to avoid that since I have to export address fields for multiple directory records which means I need to add each of those individual fields to a table for each entity. I had ran a few tests where I tried adding leading and trailing spaces and I did not see the spaces show in the export, but if this is not explicitly done on the reporting tool I am not sure I can count on that. Thanks Jeremy.