No video :(

SQL Query | Replace special characters | Control Characters | REPLACE function

Подписаться 44 тыс.

Просмотров 41 тыс.

50% 1

This video discusses another scenario bases SQL Query interview question.
How to replace special characters from a string?
The REPLACE function can be used to replace special control characters like TAB, Line Feeds and Carriage Returns.
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org

Опубликовано:

21 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 34

@gundekusha6167 5 месяцев назад

Helped alot.👍

@LearnatKnowstar 5 месяцев назад

Glad it helped

@KeshavRaj-xh6hu 2 месяца назад

Hi Team, Do you have the dataset for all the queries in this playlist. If you can arrange ,it will be very helpful for me

@PurushottamKumar-kg2uw 2 года назад

Thank you so much my issue got resolved .

@LearnatKnowstar 2 года назад

Thank you

@kristyowens2284 3 года назад

Thanks for sharing.

@LearnatKnowstar 3 года назад

Thank you

@vaishuram9782 3 года назад

Thanks for the video.. I want to replace invalid chars but want to exclude carriage return and line feed.. Please suggest

@LearnatKnowstar 3 года назад

You will need to explicitly specify the list of invalid characters you need to replace

@sandeepbisht4057 3 года назад

Thanks for this video 🙂 Can we use replace(column_name, CHAR(13)+CHAR(10),' ') In short two ASCII characters together..?... Thanks in advance 😀

@LearnatKnowstar 3 года назад

You would need to use nested replace statements - ex - replace(replace(col, 'a','x'),'b','x'). You can also try using translate function.

@dhanrajshunkalwar7098 4 года назад

Thanks for sharing

@LearnatKnowstar 4 года назад

Thank you

@gouravraj1169 14 дней назад

Hello, your videos are very helpful. Could you please help me with one scenario? I have special characters in my column like à, ñ etc. I want to find only the rows which have special characters in it.

@LearnatKnowstar 10 дней назад

Thank you

@AH-jn5ts Год назад

Thanks For the video.

@LearnatKnowstar Год назад

Thank You

@Touhid54 Год назад

Thanks

@LearnatKnowstar Год назад

Glad it was helpful.

@sweetysweetyvghb 4 года назад

Mam..please do a video on how to replace special characters in datastage..

@LearnatKnowstar 4 года назад

Thanks you. Will plan it soon.

@dravikrish7323 Год назад

Hi video quality is so poor please upload good quality. Your explanation is very goo.

@LearnatKnowstar Год назад

Please try viewing it in HD

@sagnikpoddar881 Год назад

I am getting a blank space in some datas of a particular column rest I am getting NULL values, when I am replacing the characters of asci value from 0-31 with '' and trimming it , I'm supposed to get null right ? But I'm not getting that , can you suggest a solution for it please ?

@Pranav-fg5jr 3 года назад

I use this replace function , but when I tried to export data in excel by using the query having replace function , it is giving me error. why is it so?