JupyterLab Extension for INFACore

Back Next

Remove control characters

You can apply this function to identify and remove non-printable characters in the source data.

To perform this operation, select the

Remove Control Characters

function, and specify the data object variable. Then, enter the column name that contains the control characters.

The function removes the control characters. For example, the input flat file includes a column named characters that contains control characters.

The following snippet is the input code when you apply the function:

import informatica.infacore as ic
FF_DV = ic.get_data_source("Flat File").get_connection("DR_FlatFile").get_data_object("input.csv")
dqf = ic.DataQualityFunctions()
dqf.remove_control_characters(FF_DV,"Characters")

The following snippet shows the output, where the control characters are removed:

Input_Field: string
Output_Field: string
----
Input_Field: [["	"," ","→"]]
Output_Field: [[""," ","→"]]

Rename Saved Search

Table of Contents

JupyterLab Extension for INFACore

JupyterLab Extension for INFACore

Remove control characters

Remove control characters