Hi Pete
very interesting concept!
But for my slow mind I prefer to have a more explicit output
like this
orig_concat$ = "Pete|Steve|Bill|Norma Jean|Fell|"
new_concat$ = "Pete|Steve|Norma Jean|Fell|"
seed = 1
marker$ = "|"
seed2 = 1
x$
= MID$(orig_concat$
, seed
, INSTR(seed
, orig_concat$
, marker$
) - seed
) seed
= seed
+ LEN(x$
) + LEN(marker$
)
Y$
= MID$(new_concat$
, seed2
, INSTR(seed2
, new_concat$
, marker$
) - seed2
) seed2
= seed2
+ LEN(Y$
) + LEN(marker$
) ' PRINT Y$, STR$(seed2), STR$(LEN(new_concat$))
:-)