#stringfunctions 검색 결과
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. Jalen 70.5K posts
- 2. Eagles 113K posts
- 3. Herbert 32.4K posts
- 4. AJ Brown 9,840 posts
- 5. #BoltUp 4,487 posts
- 6. #WWERaw 47.5K posts
- 7. Saquon 11.3K posts
- 8. Sirianni 5,481 posts
- 9. Patullo 6,921 posts
- 10. #PHIvsLAC 3,741 posts
- 11. Tony Jefferson 2,927 posts
- 12. Cam Hart 1,295 posts
- 13. Cameron Dicker 1,788 posts
- 14. 4 INTs 3,332 posts
- 15. LA Knight 10.1K posts
- 16. Tanner McKee 1,607 posts
- 17. Jordan Davis 1,131 posts
- 18. Dotson 1,986 posts
- 19. Greg Roman 1,421 posts
- 20. Smitty 3,115 posts