I'm trying to use the MID function on a string to be able to put all sections of data but the problem is that the starting point on each section throughout the document can be in different places and I want to be able to use a FIND within the MID to look for an occurrence of each separater
) to find the new starting point I need.
it would look like:
32000:3:9.0000:fixed|32000:16:8.5000:fixed
32000:13:23.0000:fixed|32000:6:21.5000:fixed
32000:213:109.0000:fixed
The final output would look like:
Q1 S1 Q2 S2 Q3 S3
3 9.00 16 8.50
13 23.00 6 21.5
213 109.00
Since the numbers can vary in league each starting point through out the string would be different so I'm not sure what the best approach would be.
please help.
) to find the new starting point I need.it would look like:
32000:3:9.0000:fixed|32000:16:8.5000:fixed
32000:13:23.0000:fixed|32000:6:21.5000:fixed
32000:213:109.0000:fixed
The final output would look like:
Q1 S1 Q2 S2 Q3 S3
3 9.00 16 8.50
13 23.00 6 21.5
213 109.00
Since the numbers can vary in league each starting point through out the string would be different so I'm not sure what the best approach would be.
please help.
