Nifi ConvertExcelToCSVProcessor - broken pipe separator

Question

Hello,I have a file in .xlsx format that needs to be transofmerd to .csv format with broken pipe as separator. When I enter broken pipe (¦) as Value Separator in ConvertExcelToCSVProcessor, in CSV file appears "?" as separator instead of "¦". Is there a way to convert .xlsx to .csv with broken pipe delimiter?

aakulov · Accepted Answer

Oh, I thought you had broken pipe in your Excel file, but this makes more sense. Thanks for clarifying.

Do you need to use broken pipe delimiter on the output because the target process only accepts that character as the delimiter? Seems strange that you'd use broken pipe for a csv file.

You can have ConvertExcelToCSVProcessor write out a simple comma-separated format. Then use a ReplaceTest processor to replace delimiter commas with your broken pipe hex code (see example here). Will that work for you?

aakulov · Answer

Hi @Stefi ,

It could be as simple as setting the Include Trailing Delimiter parameter to False in your NiFi processor. Then NiFi should not include any delimiter at the end of each CSV record. See this documentation page for ConvertExcelToCSVProcessor.

Hope this helps you out.

Regards,

Alex

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.