Results for "SPLIT"
4 / 184 posts
How to one series with comma separate(any Delimiter) value split into in rows
If we have one series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: IF OBJECT_ID('TF_SplitSerie…
database pivot SQL Server
Mar 19, 2026 1 min read
How to Two series with comma separate(any Delimiter) value split into in rows respectively
If we have two series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: IF OBJECT_ID('TF_SplitTwoSe…
comma saparate database mysql
Mar 19, 2026 1 min read
Split full name into first name and last name in SQL
Split full name into first name and last name : SELECT EmployeeName, CASE WHEN CHARINDEX(' ', EmployeeName) > 0 -- Check if there is a space (indicating…
microsoft programming sql-server
Mar 19, 2026 1 min read
PySpark Convert String to Array Column
To convert a string column (StringType) to an array column (ArrayType) in PySpark, you can use the split() function from the pyspark.sql.…
PySpark Convert String to Array Column SPLIT PySpark
Mar 19, 2026 1 min read