How I Replace Special Characters In a Text

[@luismiras6481]

Alejandra, impecable !!! no te imaginas lo que se siente de este lado de la pantalla. Gracias. Muchas gracias. Cuanto te admiro.

[@alejandrahorvath]

Muchísimas gracias Luis!!! Me alegra que te haya gustado. Aprecio muchísimo tu soporte y como decimos en México, esas porras que siempre me echas, me motivan muchísimo. Un abrazote hasta Argentina!!! 🤗

[@franciscom.paredesarias2356]

¡Alejandra, como te va!, espero que te encuentres muy bien. Te deseo lo mejor este nuevo año, mucho éxito y bendiciones para ti. Con respecto al video, muchas gracias por el tiempo involucrado y por seguir entregando nueva información que en mi caso desconocía de esos caracteres especiales. Y la forma dinámica de remplazo que ensañas es de gran ayuda. Saludos desde Chile 🤗

[@alejandrahorvath]

Hola Francisco, que gusto!! 😊 Muchas gracias por tu lindo mensaje, espero que estés muy bien. Que este 2024 esté lleno de paz, salud y mchos éxito! Me alegra que hayas encontrado este video útil. Te mando muchos saludos hasta Chile 🤗

[@ziggle314]

Excellent post! I will be using this technique on my file cleaning operations. Like you, I usually have to deal with removing #(cr) and #(lf) characters, plus the dreaded non-breaking line feed #00A0). As far as how to tell what characters are there, to my knowledge, PQ does not have a way to view the characters in the editor. To see what is there, I either: 1. View the file in Notepad++ and select show all characters. Notepad++ may be the easiest approach because it will actually show you an LF or CRLF at the end of the lines. 2. Copy one of cells while in PQ. Paste the string into Excel, then use the Mid and CODE functions to look at each character in that string and see what is in there. 3. Try every option while in PQ (kind of like you did). In theory, we could make a PQ function that tells us what is in there. I might try that today. You have inspired me! Thanks Alejandra.

[@alejandrahorvath]

Awesome Mark! I will try the options that you listed. 😀 Glad you found the post useful. 😊 What a great idea to create a function! Thanks for watching 😊

[@shivmantra1406]

Wow. This is brilliant Alejandra

[@alejandrahorvath]

Glad you liked it! Thanks for watching 😊

[@movies4ever275]

beautiful, nice solution to handle multiple replacements

[@alejandrahorvath]

Glad you liked it. Thanks for watching 😊

[@rajanair79]

Thank you, this was helpful

[@alejandrahorvath]

Glad it was helpful! Thanks for watching 😊

[@cdmkk2211]

Excellent

[@alejandrahorvath]

Glad you liked it! 😊