Try our plataform
Remove EQL

Remove EOL

Description

Removes EOL (end of line/newline) characters from any part of the text.

Category

Transformation

Supported Field Types

  • text

Output Field Type

  • text

Arguments

None

Pseudo-code (Python)

def func(val):
    """
        val: value of the text field
    """
    import re
    if val:
        return re.sub(r'[\n\r]+', '', val)
    else:
        return None

Remove EOL characters from text fields

Apply the Remove EOL transformation in Kondado to strip newline and carriage-return characters from text data before loading it to your destination.

1
Identify text fields with line-break issues

Locate text fields in your source data that contain unwanted newline (\n) or carriage-return (\r) characters that may break CSV exports, spreadsheet imports, or string matching downstream.

2
Open the pipeline transformations

In the Kondado platform, open the pipeline that handles the affected field and go to the transformations step.

3
Apply the Remove EOL function

Add the Remove EOL function to the target text field. No arguments are required: it strips all line breaks via the regex [\n\r]+ and returns None when the input is null or empty.

4
Validate the cleaned output

Run a test execution and confirm the output is still text type but free of newline characters, so it loads cleanly into your destination.

5
Save and replicate to destination

Save the pipeline so the transformation runs automatically on every replication, keeping the data clean at the frequency you choose.

Frequently asked questions

What does EOL stand for in the Remove EOL function?▼
EOL stands for "End of Line" or "newline." The Remove EOL function removes newline (\n) and carriage-return (\r) characters from any part of a text field, cleaning the data for consistent processing in your data transformation workflows.
Does Remove EOL require any configuration arguments?▼
No. The Remove EOL function accepts no arguments. You simply apply it to a text field, and it automatically strips all newline and carriage-return characters using the regex pattern [\n\r]+.
What field types does Remove EOL support?▼
Remove EOL supports only the text field type as input, and it also outputs a text field. It will not work on numeric, date, or other non-text field types.
When should I use Remove EOL in my data pipeline?▼
Use Remove EOL when source data contains unwanted line breaks that could cause formatting issues in destinations, break CSV exports, create problems in spreadsheet imports, or interfere with string matching and deduplication logic in your analytics workflows.
What happens if the input value is null or empty?▼
If the input value is null or empty, the Remove EOL function returns None (null) rather than attempting to process it, preventing errors in your pipeline execution.
Written by·Published 2024-12-20·Updated 2026-04-26