Top Tweets for #stringfunctions
SQL Tip of the Day #109: Use CHARINDEX() to Find Position of a Substring
SELECT CHARINDEX('@', email) AS AtPosition
FROM Users;
Useful for basic email validation and parsing.
#SQLTips #StringFunctions #DataValidation #LearnSQL
split(str, [delimiter]) splits strings/vectors—auto-CHAR vec if no delimiter!
✂️Use a delimiter for CHAR/STRING vecs; vector input returns columnar tuples. Ideal for text parsing.
#DolphinDB #StringFunctions #TextParsing
rpad(str, length, [pattern]) pads strings on the right with your chosen pattern!
🧩Reach the target length easily—great for text alignment or standardizing string formats.
#DolphinDB #StringFunctions #TextFormatting
![DolphinDB_Comm's tweet photo. rpad(str, length, [pattern]) pads strings on the right with your chosen pattern!
🧩Reach the target length easily—great for text alignment or standardizing string formats.
#DolphinDB #StringFunctions #TextFormatting https://t.co/WVQErzgrfs](https://pbs.twimg.com/media/G6l6Oh4aQAERAI_.png)
repeat(X, n) returns the string X repeated n times! 🔁
Super simple for duplicating text—ideal for quick string generation or pattern creation.
#DolphinDB #StringFunctions #TextGeneration
lpad(str, length, [pattern]) pads strings (or table string cols) on the left!
🧩Ignores non-string columns—customize padding with an optional pattern. Perfect for text alignment.
#DolphinDB #StringFunctions #TextFormatting
![DolphinDB_Comm's tweet photo. lpad(str, length, [pattern]) pads strings (or table string cols) on the left!
🧩Ignores non-string columns—customize padding with an optional pattern. Perfect for text alignment.
#DolphinDB #StringFunctions #TextFormatting https://t.co/BkSATpGyPm](https://pbs.twimg.com/media/G6MIx_caIAA_evS.png)
left(X, n) grabs the first n characters of X!
←Works on strings + table string columns (ignores other column types). Perfect for quick text slicing.
#DolphinDB #StringFunctions #DataSlicing
charAt(X, Y) fetches the character at position Y in string X! 🔍
Returns a CHAR type—handy for precise string slicing and text parsing tasks.
#DolphinDB #StringFunctions #TextProcessing
charAt(X, Y) fetches the character at position Y in string X! 🔍
Returns a CHAR type—handy for precise string slicing and text parsing tasks.
#DolphinDB #StringFunctions #TextProcessing
SQL Tip of the Day: Use LEFT & RIGHT to Extract Fixed-Length Strings
SELECT LEFT(postal_code, 3) AS RegionCode FROM Addresses;
Simple way to extract string chunks without SUBSTRING().
#SQLTips #StringFunctions #LearnSQL #TSQL
SQL Tip Of The Day
Use REVERSE() to Flip Strings
SELECT REVERSE('SQL'); -- Outputs LQS
Niche, but fun and sometimes useful.
Ever had to reverse strings?
#SQLTips #StringFunctions #LearnSQL
SQL Tip Of The Day
Use PATINDEX for Pattern Search in Strings
SELECT PATINDEX('%@%.com%', email)
FROM Users;
Similar to LIKE but returns position.
Use it for validations?
#SQLTips #StringFunctions #DataQuality #LearnSQL
Day 3 of #LearningBasicPython with #Shahzeb_Codes
🧠 Today’s String Functions in Python:
• len()
• endswith()
• startswith()
• upper() / lower()
• find()
• replace()
ImportantTools for Python in Data Science ,AI
#Python #PythonForBeginners #day4 #stringfunctions
#Attached are the visualizations I practiced with today.
@tableau
#TableauTips #StringFunctions #DataPreparation #AnalyticsJourney
2. Calculating the Number of Days Since Each Sale – I also wrote a query to calculate how many days ago each sale happened. Here’s the solution:
#SQL #DataAnalytics #StringFunctions #DateFunctions #DataCleaning #SQLChallenge #LearningJourney #TechJourney #DataWrangling
Day 4
I used string functions( LENGTH, INSTR, SUBSTR, CONCAT, TRIM, etc) to clean format, extract, and modify data within my database.
#Day4 #30DaysOfSQL #SQL #StringFunctions #Data
A Simple Guide to SQL Functions for Data Analysis! 📊✨ Explore Aggregates, Strings, and Dates with ease
Check our LinkedIn page for details: https://t.co/lfC9swNjtM
#SQL #DataAnalysis #AggregateFunctions #StringFunctions #DateFunctions #Database #SQLSyntax #Coding #Programming
Article I found title “39 PHP String Functions You Can’t Live Without,” by Mark Harbottle, from Sitepoint’s website, link below.
#PHP #StringFunctions #WebsiteDevelopment https://t.co/RC9tvbdccA
JavaScript string methods
..............
#JavaScriptStringMethods, #StringManipulation, #JSStrings, #StringFunctions, #JSCode, #StringProperties, #SubString, #StringMethods, #CharAt, #Replace
Diving deep into string functions lately! 📘 Mastered CONCAT, SUBSTRING, REVERSE, and more. Data manipulation just got a level up. 🚀
#MySQL #DataSkills #StringFunctions #ContinuousLearning
Last Seen Hashtags on Sotwe
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
240.1M followers
Barack Obama
@barackobama
119.3M followers
Donald J. Trump
@realdonaldtrump
111.6M followers
Cristiano Ronaldo
@cristiano
108.8M followers
Narendra Modi
@narendramodi
106.9M followers
Rihanna
@rihanna
97.2M followers
NASA
@nasa
92.1M followers
Justin Bieber
@justinbieber
90.5M followers
KATY PERRY
@katyperry
86.7M followers
Taylor Swift
@taylorswift13
80.5M followers
Lady Gaga
@ladygaga
72.1M followers
Kim Kardashian
@kimkardashian
69.3M followers
YouTube
@youtube
68.6M followers
Virat Kohli
@imvkohli
68.4M followers
Bill Gates
@billgates
63.4M followers
The Ellen Show
@theellenshow
62.5M followers
CNN
@cnn
61.9M followers
Neymar Jr
@neymarjr
60.9M followers
X
@x
60.9M followers
CNN Breaking News
@cnnbrk
59.9M followers