Hi, I have requirement to generate a specifically formatted csv file. For

Hi,
I have requirement to generate a specifically formatted csv file. For instance, column 1 must be 4 characters, column 2 must be 4 character, column 3 must be 14 characters (and right justified) and so on. There are 186 columns. However, not all columns need to be filled in. We will just have 20 columns that are mandatory and we can populate those columns with data from the process. This means there will be many blank columns but we still need to allocate the spacing for these columns in the csv file because the system that it will be imported to is very specific on the format.
Can anyone suggest a way on how this can be done? I was thinking of some sort of "csv template" and then populate it with data but I don't know if this is do-able. Any suggestions would be appreciated.

Thanks,
Gary

OriginalPostID-176111

OriginalPostID-176111

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data