split cell value in ms access code example

Example: access split field by delimiter

Split("Tech on the Net")
Result: {"Tech", "on", "the", "Net"}

Split("172.23.56.4", ".")
Result: {"172", "23", "56", "4"}

Split("A;B;C;D", ";")
Result: {"A", "B", "C", "D"}

Split("A;B;C;D", ";", 1)
Result: {"A;B;C;D"}

Split("A;B;C;D", ";", 2)
Result: {"A", "B;C;D"}

Split("A;B;C;D", ";", 3)
Result: {"A", "B", "C;D"}

Split("A;B;C;D", ";", 4)
Result: {"A", "B", "C", "D"}