I have a record like this
This is a great one 03245445Might even go home 545455
this is one record that looks exactly like the real thing
the first bit is 19 char long = This is a great one
2nd is 9 = 03245445
3rd is 19 = Might even go home
4th is 6 = 545455
what i need to do is final result
This is a great one:idtnum-03245445:
STATEMENTS-ID-Might even go home:zip-545455
now i was think of first breaking each part up and storing the value to a variable then doing a replace for additional info and then making a variable that pieces it all together. Is that the best solution.
firstpart = left$(record.fields, 9)
the char lengths will always be the same the words will not except for the ones that I am manually adding.
this is in visual basic 6.