Skip to main content
Solved

Replace new line character in csv

  • July 6, 2026
  • 2 replies
  • 22 views
S
Data Pioneer
Forum|alt.badge.img

Hello

I am getting new line character while extracting metadata (column name) from catalog in DQC. I need to replace that with space. Data is extracted as a csv and this new line character is breaking my csv. How can I do that? 

Best answer by Katerina

Hi ​@sumisha ,

We can use expression in column assigner step such as

replace(replace(replace(field, '\r\n', ' '), '\n', ' '), '\r', ' ')

it should work if the newline characters are already part of the field value.

Kind regards,

Katia

    2 replies

    K
    Ataccamer
    Forum|alt.badge.img+2
    • KaterinaAtaccamer
    • Ataccamer
    • Answer
    • July 6, 2026

    Hi ​@sumisha ,

    We can use expression in column assigner step such as

    replace(replace(replace(field, '\r\n', ' '), '\n', ' '), '\r', ' ')

    it should work if the newline characters are already part of the field value.

    Kind regards,

    Katia

      S
      Data Pioneer
      Forum|alt.badge.img
      • sumishaData Pioneer
      • Author
      • Data Pioneer
      • July 8, 2026

      Thanks Katerina

      Community Terms of Use & ConditionsAccessibility statement