we are trying to create an export of data that must strictly adhere to a specific format.
This requires us to generate a text file that uses an "ASCII field separator character with a value of "1C" (binary value 28).
so I'll basically want to be exporting a txt file that runs like:
field1 (field separator) field 2 (fs) field3 (fs) (carraige return)
Can someone point me in the right direction for exporting in this type of format. Basically the delimited formats I can see by default will not work due to the delimiters. I have included the specific format instructions per the format below.
are separated (delimited) by ASCII “Field Separator” characters. (An ASCII field separator (FS) character is a 1-byte code with a hexadecimal value of ‘1C’. (The binary value is 28 and in many software programs can be coded by holding down the Alt key while typing 28 on the numeric keypad.) Each FS character marks the end of one field and the beginning of the next. As with prior versions of the format, each record is terminated with CRLF (carriage-return+line-feed) hexadecimal ‘0D0A’ characters. Trailing unused fields need not be marked by FS Field Separator delimiters. (In order to maintain continuity with previous releases of the FEC format, double-quote mark characters are not allowed within text fields.)