A few days ago I needed to split a string into several fields, obviously with a pre-defined separator character (semicolon).
My purpose it was decompose the following text :
‘5/10/2007;;”Ronald Reed “;211001;;-75.00’
in the following fields :
5/10/2007
null
Ronal Reed
211001
null
-75.00