JohnDanter2
VIP Member
Hi folks
I have to write a bank payments file and CSV is a format they can take, so to save time I've just made a CSV type UBE, but.....
I've noticed in notepad the output is like this, but they need the values surrounded in quotes
BULKCSV,GLOBAL TURNKEY (SINGAPORE),BANTABCDEFWF,KXXSXYZKC,20240507,SG9678240507161152.CSV,TEST
If I wrap the text in quotes in the UBE itself I end up with this mess
"""BULKCSV""","""GLOBAL TURNKEY (SINGAPORE)""","""BANTABCDEFWF""","""KXXSXYZKC""","""20240507""","""SG9678240507162150.CSV""","""TEST"""
Short of me making a CSV file myself using a long concat srting and output to flat file BSFNs (something I was hoping to avoid), how do I get E1 to make a CSV with quotes around each column, like this
"BULKCSV","GLOBAL TURNKEY (SINGAPORE)","BANTABCDEFWF","KXXSXYZKC","20240507","SG9678240507162150.CSV","TEST"
Thanks
John
I have to write a bank payments file and CSV is a format they can take, so to save time I've just made a CSV type UBE, but.....
I've noticed in notepad the output is like this, but they need the values surrounded in quotes
BULKCSV,GLOBAL TURNKEY (SINGAPORE),BANTABCDEFWF,KXXSXYZKC,20240507,SG9678240507161152.CSV,TEST
If I wrap the text in quotes in the UBE itself I end up with this mess
"""BULKCSV""","""GLOBAL TURNKEY (SINGAPORE)""","""BANTABCDEFWF""","""KXXSXYZKC""","""20240507""","""SG9678240507162150.CSV""","""TEST"""
Short of me making a CSV file myself using a long concat srting and output to flat file BSFNs (something I was hoping to avoid), how do I get E1 to make a CSV with quotes around each column, like this
"BULKCSV","GLOBAL TURNKEY (SINGAPORE)","BANTABCDEFWF","KXXSXYZKC","20240507","SG9678240507162150.CSV","TEST"
Thanks
John
Last edited: