access split field by delimiter 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"}