Thanks. I basically had it just wasn't casting the text field as varchar(max) so was having issues with the LEN -1. But also ended up using your code with a few changes as I wasn't accounting for no tab after the first string. thanks.