Split a Delimited String in a DataFrame
Are you needing to split a string inside a column of a pandas DataFrame? Do you want to […]
parse
Parse a String in Python
Do you need to parse a delimited string in Python? Is you string comma-delimited? Are there several strings […]
Excel Find Nth Occurrence of Char in a String
In Microsoft Excel, what formula would you use to find the Nth occurrence of a character (or string) […]
T-SQL Parsing To Get Frequency
This post is about determining just how many parts there are in a string that is delimited with […]
SQL Find Nth Occurrence of Char in a String
T-SQL’s CHARINDEX() function is useful for parsing out characters within a string. However, it only returns the first […]
T-SQL Parsing Into Many Columns
This post is about working with one column in a SQL Server table that contains a comma-separated list […]
T-SQL Parse a String 2
In this post I’ll discuss how to parse a string in SQL Server so that you can move […]
T-SQL Parse a String
In SQL Server, do you have a table with a column that has several values in it that […]
Multiple Genres in Genres Column
This post discusses the code for a movie database that has a table with a list of genres […]
T-SQL Parse a String in a Column
Do you have a column in your SQL Server database that contains a list of things separated by […]
WPF Validating 9-digit SIN
In this post we will look at the validation of a 9-digit Social Insurance Number (SIN) from Canada. […]
WPF Weather API with DataGrid
In this example program we have a DataGrid that is filled with data from an API. This is […]