Handling Batch Redaction with Line Breaks in CSV Files

Modified on Wed, Feb 12 at 1:39 PM


Problem: In PrizmDoc, when redacting phrases containing spaces in a CSV file, the redaction process may fail if the phrase is split across multiple lines within the document.  


For example, if the CSV contains the phrase "with some spaces" and "with some" appear on one line while "spaces" appears on the next, the redaction service might not recognize the complete phrase and therefore skip the redaction.  This happens even if the redaction request is correctly formatted and included the target phrase.



Solution: Modify the regular expression in your redaction request to handle line breaks:

  • Replace spaces with + (one or more occurrences) or ? (zero or one occurrence).
  • Example: Use the regex  with+some+spaces instead of just the phrase.  This will match even if the words are on different lines.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article