Skip to content
Advertisement

Tag: strsplit

Splitting strings in SQLite

Does anyone know how to split my address columns. I would like to divide it into three new columns, seperated by it’s commas. For example 1808 FOX CHASE DR, GOODLETTSVILLE, TN is divided into 1808 FOX CHASE DR GOODLETTSVILLE TN So far I’ve tried Although I cannot create the third column with the state abbreviation. Thanks for any input Answer

Advertisement