Solved
drop a column from csv
how can i drop column from csv
i only want to keep one selected feild
Let's assume your input FlowFile content looks like this:
Date, IP, Description
01-30-2020, 10.0.0.1, server1
01-30-2020, 10.0.1.2, server2
01-30-2020, 10.0.3.4, server3
01-30-2020, 10.0.4.6, server4
01-30-2020, 10.0.10.2, server5
You would configure your ReplaceText processor as follows:
The Search Value contains a java regular expression which will match on your entire line and uses one capture group. The Replacement Value says to replace everything matched by the Search Value Regex with only the value from capture group 1. We then configure ReplaceText to evaluate that Regex against each line.
The resulting FlowFile output to the success relationship will have content that looks like this:
IP
10.0.0.1
10.0.1.2
10.0.3.4
10.0.4.6
10.0.10.2
Hope this helps,
Matt
