Remove Page Breaks or special character

Good Morning ! I do a reading of a text file that has a page break and I can not remove the special character, I have already used some functions and objects like Data Cleasing and Regex, but the line is generated blank, if we visualize there is a character symbol. Has anyone had this problem yet?

Regex

Transformation

Preparation

Accepted answers

jdunkerley79

This expression will get rid of them:

Replace([Field_1], CharFromInt(12),"")

Then should be able to be processed as you want

RemoveChar12.yxmd

All comments

jdunkerley79

You could try to identify the specific character code using the CharToInt function. That might make it easy to identify what you need to replace.

You could also do a REGEX function like:

REGEX_Replace([Field_1],"[^\w ()-\\/{}\[\]]","\b")

WHere you define the allowed characters in the square brackets after the ^.

luizbezerra

Actually for integer brings the value 12 to localized line, but does not replace the special character, I'm attaching an example text to get idea

TEXT.txt

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703