Re: String-manipulating

Hi Erik, > > Suppose You have a char field containing strings of the format <prefix><middlefix><suffix> where > the prefix and suffix can be anything and with any length. OK, now You know the middlefix to be > exactly "TLLCC" and You want it, badly, to be "TLC", what do You do ?? > One way is to dbexport the table, sed-it a litte and then dbimport it, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ I think you hit the nail on the head. Before you dbimport, why not change the table so that the prefix, "middlefix" and suffix are in separate columns :-) > but is there an easier way Sadly, I think not :-( Cheers, Richard.