I need to format a Flat File Fixed Length report for a client. In it they have allocated 12 characters for the patients phone number. In the file output, I need to format the phone exactly like this:
I would like to know what would be the best way to right this value? I need to account for NULLs and if there is a NULL I need 12 blank spaces.
My field name is pp.Phone1