question Re: WORD REPLACEMENT USING DICTIONARY FILE IN NIFI in Support Questions

WORD REPLACEMENT USING DICTIONARY FILE IN NIFI

Syamim — Mon, 19 Aug 2024 06:43:58 GMT

Hello everyone.

So I've been finding on How to Perform Word Replacement in a csv file by using a Dictionary File as the Guide.

I've yet unable to succeed in doing this. I was hoping to get it done with just a single dataflow and just by using processors (without script) but I don't know what processors to use. I've tried a few but nothing seems to work. Hopefully I can get help.

The input csv file i have is named try.csv which contains the words that need to be processed (word replacement takes place).

While the dictionary file is named syno_street.csv which have a couple of rows and 3 columns:
column1: original word (need to be searched in input csv)
column2: original word (need to be searched in input csv)
column3: replacement word (the output after processing)

syno_street.csv:

try.csv: (input csv for testing)

Thank you in advance.

Re: WORD REPLACEMENT USING DICTIONARY FILE IN NIFI

VidyaSargur — Tue, 20 Aug 2024 06:19:46 GMT

@Syamim, Welcome to our community! To help you get the best possible answer, I have tagged our NiFi experts @SAMSAL @MattWho @mburgess who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Re: WORD REPLACEMENT USING DICTIONARY FILE IN NIFI

Syamim — Tue, 20 Aug 2024 08:54:42 GMT

Hello,

For the try.csv input, I've successfully configured it. However, what I didn't succeed is when I change the content of the input file to have strings at the front and the back of the words that need to be replaced.