String field being treated as numeric value?

Question

My report is pulling data from a CSV on a network drive (long story, but source application is antiquated).

The field 'Docket Num' (=[DocketNum]) is configured in the Universe as a string, but the report appears to be interpreting it as a numeric value.

Example of CSV content

Example of report output

To troubleshoot the issue, I tried manually altering the contents of the CSV to remove the non-numeric characters:

Example of altered CSV content

Example of altered report output

The report then displayed as expected which seems to confirm that the report is having trouble interpreting the data type correctly.

Is there a function or cube transformation that I can apply to force it to return the string?