I want to split lines of text delimited by "|" to form a 4 dimensional array from the contents, for use in a UserForm. Is there a RegExp or similar to do this neatly? The delimiter can be changed if this would make life simpler. The lines will be read from a text file (attached)
MD


001|P:\1028 Crieff Golf Club DDA\14.04.04\|140404-001.jpg|Stair Landing
002|P:\1028 Crieff Golf Club DDA\14.04.04\|140404-002.jpg|Toilet Entrance
003|P:\1028 Crieff Golf Club DDA\14.04.04\|140404-003.jpg|No wheelchair access at bars