How to write a zero length string (empty string) instead of null with tPostgresqlOutputBulk
I can't get this to work. Even if I tmap the field to "", it still is written as null in postgresql. The bulk file is created with nothing between the delimiters. If I manually edit the bulk file to "" instead of blank, then I get a null string.
The only thing I can think to do is to map a single space (" "), and then after writing the bulk file, using treplace to convert all " " to "".
Is there anything better? (Note the bulk file is created as csv)
Hi
I have made a testing and I got the same issue, what we can do is to replace " " with "" after the bulk file is created, use tReplace as you did or use tFileInputRaw to read the whole file content as a string, replace all " " with "" and then create a new bulk file.
tFileInputRaw--main--tJavaRow--tFileOutputRaw.
on tJavaRow:
//Code generated according to input schema and output schema
output_row.content = (input_row.content).toString().replaceAll(" ","");
Hi
I have made a testing and I got the same issue, what we can do is to replace " " with "" after the bulk file is created, use tReplace as you did or use tFileInputRaw to read the whole file content as a string, replace all " " with "" and then create a new bulk file.
tFileInputRaw--main--tJavaRow--tFileOutputRaw.
on tJavaRow:
//Code generated according to input schema and output schema
output_row.content = (input_row.content).toString().replaceAll(" ","");
