#stringfunctions search results
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
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
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
📅 PHP Coding Tips - Day 91 ❗️Use str_contains() for Clean String Checks 🔍 ✅ Available since PHP 8. ❓ Still using strpos()? #PHP #ModernPHP #StringFunctions #100DaysOfPHP
#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
Something went wrong.
Something went wrong.
United States Trends
- 1. Good Tuesday 40.4K posts
- 2. The BONK 105K posts
- 3. #tuesdayvibe 2,491 posts
- 4. FINALLY DID IT 564K posts
- 5. #PueblosPorLaPaz 2,162 posts
- 6. Taco Tuesday 13.1K posts
- 7. Leon 62.3K posts
- 8. Oslo 82.9K posts
- 9. Jasmine Crockett 95.2K posts
- 10. Piers 97.8K posts
- 11. Ty Howle N/A
- 12. Politico 115K posts
- 13. Rich Paul N/A
- 14. Compromised 19.7K posts
- 15. #NXXT_NEWS N/A
- 16. Jalen 86.1K posts
- 17. #Haus64xLingMOME 836K posts
- 18. LINGLING BA HAUS64 835K posts
- 19. Judah 4,589 posts
- 20. Paredes 11.1K posts