I need a function to parse data between (- ) or ( , ) or ( . ) or ( / ). These could be in different locations within the string. I need to be able to parse between the first (.) and the second (.) or any one of the other (- ) or ( , ) or ( . ) or ( / ).
String is as follows: .AACTS 2001.6400.680.SDC
I need to separate the data into a table as
Field1 = ACCTS 2001
Field2 = 680
Field3 = 6400
Field4 = SDC