No video :(

SQL Query | How to Extract Numbers and Alphabets from an alphanumeric string | Translate function

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

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

50% 1

This video discusses the SQL Interview Question
How to extract numbers and alphabets from an alpha numeric string
Solution is provided using SQL Translate function.
Datastage Extract Numbers and Alphabets
know-star.blogs...
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

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Thank you so much! This is exactly what I was looking for!

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

Glad that it was useful!

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

Your video helped so much. Thank you!

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

Thank you!

@SEEMAKUMARI-gy8il Год назад

Thank you so much mam, it is very helpful video and please provide us create and insert query ,it will help us for practice

@LearnatKnowstar Год назад

Thank you

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

Thanks for posting this. What is the difference between replace and translate?

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

Replace is used to replace a single character. Translate can replace multiple characters.

@monalikharabe4703 Год назад

Awesome thank you so much....

@LearnatKnowstar Год назад

Glad it was helpful.

@naveenkumark6093 Год назад

🎉🎉 super stuff

@LearnatKnowstar Год назад

Thank you!

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

Great stuff. Please post the SQL query using PATINDEX as well.

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

Thank you

@ItsWithinYou Год назад

Excellent! Thanks for sharing!

@LearnatKnowstar Год назад

Glad it was helpful.

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

Very helpful tutorial. Thank you!

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

Thank you

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

nice.. how to extract this: drink#eat#drive#sleep, to output DrinkEatDriveSleep

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

Thank you for your query. In this case, you will first need to extract the position of # using the pat index or charindex function. Then we can capitalize the first alphabet of the words. Lastly, replace function can be used to replace # with empty space. We will post the video with the solution for your query soon.

@andersonnunes9800 Год назад

Just Perfect!!!

@LearnatKnowstar Год назад

Glad it was helpful!

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

Amazing explanation mam 👏

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

Glad you liked it

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

Amazing ! Thanks!

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

Thank you

@sarathchandra4276 Год назад

If this is the case we can simply use left and right operators in sql to seperate please solve the same when alphanumeric string is combined as'xas123ssh333'.

@AkshayPathania-ck1wy Год назад

Very help full

@LearnatKnowstar Год назад

Thank you

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

Awesome video!!!!

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

Thank you 🙏

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

Hi, How do you separate alphabets from this data for example A256-20G, A658-78L, G588-100ML, I just only pull unit only (G, ML, L). any solution?

@crazydreamwalker 6 месяцев назад

Step 1 : create a user defined table valued function to separate the delimited values into separate rows Step 2 : Use substring to get the last two chars Step 3 : Use translate to remove any numeric values in 1st position.

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

Thank you for video , if name and number mixed like '45875RAMA4785KRISHNA'

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

This query will extract all the numbers into one column and all the alphabets into another column.

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

mam, i tried this query in the example "ne1e9r94aj" but it gave me output like "ne e r aj" including spaces even after using trim also ,so How to get the output like "neeeraj"