Paul Smith wrote: > Dear All > > I have a long spreadsheet as follows: > > X1 X2 X3 X4 X5 > 2 6 1 1 4 > 2 1 3 1 5 > 3 3 3 4 6 > 4 2 5 3 4 > 6 6 5 1 1 > 5 6 4 1 3 > > [...] > > For each number and for each X variable, there is a small piece of > text. I am looking for a program to replace, for each spreadsheet line > and for each number therein, the respective text and create a phrase > concatenating the pieces of text corresponding to the numbers. Is > there some tool to accomplish this goal? > > Thanks in advance, > > Paul > Depending on the format of the spreadsheet, you may be able to use sed to do this. You may also be able to use the find/replace function of the spreadsheet program. Mikkel -- Do not meddle in the affairs of dragons, for thou art crunchy and taste good with Ketchup!
