question Re: Replace /N with empty string in CSV File in Support Questions

Replace /N with empty string in CSV File

aridif — Sat, 03 Aug 2019 04:19:22 GMT

I have a CSV file in which nulls are represented by "/N". How can i go about replacing this with an empty string ''.

Sample

Year Age City Date

2013 \N London \N

2019 56 \N \N

2015 20 \N 12/12/2019

I would like to replace this, so that the file looks like the below.

Year Age City Date

2013 London

2019 56

2015 20 12/12/2019

Which processors can i use to achieve this and what is the syntax to be used.

Re: Replace /N with empty string in CSV File

Shelton — Sat, 17 Aug 2019 23:21:35 GMT

@FA

Use a ReplaceText processor which replaces \A\n|\n*\s*(?=\n) with '' (empty replacement value). The search regex looks for:

\n*\s*(?=\n) - newline (0 or more) followed by whitespace (0 or more) followed by a newline.

Re: Replace /N with empty string in CSV File

ask_bill_brooks — Sat, 03 Aug 2019 22:00:33 GMT

The above question and the entire response thread below were originally posted in the Community Help track. On Sat Aug 3 14:59 UTC 2019, a member of the HCC moderation staff moved it to the Data Ingestion & Streaming track. The Community Help Track is intended for questions about using the HCC site itself.

Re: Replace /N with empty string in CSV File

aridif — Sat, 17 Aug 2019 23:21:27 GMT

I was able to solve the problem by using ReplaceText processor below. For Replacement Value, I hit "tab"

Re: Replace /N with empty string in CSV File

aridif — Sun, 04 Aug 2019 05:12:11 GMT

This was helpful

Re: Replace /N with empty string in CSV File

Shelton — Sun, 04 Aug 2019 14:48:04 GMT

@FA

Great that your problem was resolved.