It is no surprise that my script doesn't work with your new data. This is a completely different problem from what you posted in your original message in this thread (in fact from any of the 12 different versions of that message). In your original problem, any line with three or more "words" on the line had a number as the last word and that word was to be modified by the list you supplied in the variable named Variable. So my script copied lines with less than three words to the output without changing them and made the change you requested to the last word on all lines with three or more words.

The fact that you have also changed your last message six times is also a bit disconcerting.

You say that the script isn't working with your new data, but you haven't shown us what output you want. You have 27 values in Variable and you have 30 lines in your sample input file that have a last word that is entirely numeric. How is the script supposed to determine which lines are to be modified? If you can tell me how to recognize lines that need to be modified, it can be made to handle any character you want as a field separator. But you have to CLEARLY describe your input file format and your output file format.

Note also that your 1st set of requirements had all replacement values with 5 digits after the decimal point and you wanted 5 digits to be printed after the decimal point for the values that were calculated and did not add any lines to your output file. Your 2nd set of requirements had some replacement values with 5 digits and some with 6 and you wanted the calculated value to be printed with the same number of digits after the decimal points as were in the replacement value for that line and requested that the line:

Code:

New File generated

be added as the first line to appear in the output file.

Now it looks like you're back to only having 5 digits after the decimal point. Can the script assume that all computed values should be printed with 5 digits, or should it determine the number of digits to be printed based on the number of digits being used in each number involved in the calculation on that line?

Do you want any lines to be added to your output file? If so, what should they be?

When you have a variable that is to be expanded by the shell, it needs to be inside double quotes; not single quotes. I.e.:

Code:

awk -v Variable="$NUMBERS"

not:

Code:

awk -v Variable='$NUMBERS'

But, it would be more efficient to just let awk read the contents of your list of replacement values from the file that you are using to set the variable. What is the name of the file that you are using to initialize the value of $NUMBERS? Inside that file, is each value on a separate line, or are there multiple values on input lines? If there are multiple values on lines, what is the separator between values?

In the future, if you want our help, please post sample input that is representative of the input you want to process, clearly state the algorithm to be used to convert your input to the output you want, and provide sample output that EXACTLY corresponds to the sample input and the algorithm you specify. Constantly changing requirements wastes our time and your time.