String decomposition

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