Member since
06-18-2021
4
Posts
0
Kudos Received
0
Solutions
06-18-2021
01:26 PM
Yes, ReplaceText processor helps. First I convert to csv with regular pipe as delimiter, and after that I replace it with broken pipe. Thanks!
... View more
06-18-2021
12:23 PM
Hi @aakulov Fiirst picture is example of .xlsx file, second picture is what I get, and third what I want to get. Did you mean first to convert excel to csv with comma delimiter, and then to use ReplaceText to replace comma with broken pipe? I don’t have broken pipe in excel file, why to use ReplaceText on original .xlsx file first? Thanks!
... View more
06-18-2021
10:58 AM
Hi @aakulov , Thanks for answer. I just checked and this parameter was set to false, as you can see at the picture. When i use a regular pipe | the csv file is ok, but when when I use broken pipe, I get ? as separator between fields in one record, instead of ¦
... View more
06-18-2021
06:24 AM
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?
... View more
Labels:
- Labels:
-
Apache NiFi