Hello ,
I have a file that has “|” as the column delimiter and the record delimiter is a “~” character.
I having trouble reading this file , how do I make Clover ETL that this is the record delimiter.
By the I think Clover ETL is a wonderful tool powerful/flexible. Great JOB!!!
The above approach works only if they still have the \n character at the end of each record.
-Shiva
In the configuration XML file:
<?xml version="1.0" encoding="UTF-8"?> ................ ................NOTE: The last element is used for the line delimiter.
Regards,
Shiva
I am sorry for the confusion. The above logic doesn’t work for record delimiter.
-Shiva
Hmm, I am not sure what you mean, exactly. If you use DELIMITED_DATA_READER_NIO, then you don’t have to have “\n” at the end of your record. There can be anything - string of arbitrary length.
Grrr. Sorry, I am really st…id. You can of course specify delimiter which is longer than 1 character.
Forget extra dummy field.
In case your last field is separated from next record by “|~” characters, just put these two into delimiter attribute.
Actually, the question is whether each field is separated by “|” (pipe) , even the last one and
the whole record is separated by “~” (tilda).
Then use “|” in delimiter parameter and add at the end one more field - dummy field and specify that it has “~” as delimiter. Make it “string” type of field and specify that it is nullable.
It should solve the problem. If not, let me know at david.pavlis@centrum.cz