Search Results

@Don.. Thank you for fixing the code and telling me the issue.

Actually I need to extract last 100 columns and columns numbers changes everyday that's why can't use awk '{print...

@Rudi

Input File


NAME 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
A 10 20 30 40 ...

I am trying to fetch 1st column and last 10 columns.The code I am using is working fine but after using the code then output file becomes space delimited not tab delimited.


awk 'BEGIN...

Sorry about that yes I see it now and tested it thank you so much.

@Rudi.Thank you code worked as expected.

@Don it is adding Bad to all the values from column 7 to 13 if there is warning. I just want to add to the value which is not suppose to be zero.

...

@Don ..I have tried multiple things but none of them seems working

one of those :-

awk '
BEGIN { # Initialize skip array: S[fn] = char
# If field #3 contains the character specified by...

would it possible if code can add also "Bad" to value which is suppose to be zero but it is not.


COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6 SMS Email AO Mail Post N Cell Newcolumn...

@Ravinder...Rudi's code is working without script that's was only for Don's code

@Don ..Yes you and Rudi were right about P and N . Your code is working fine only one issue when I am running it, it is giving me list of files in that directory and gives the output.

doing...

@Rudi...yes you are right and code is working perfectly fine..Thank you.

would it be possible if you can explain the code ?

@Ravinder your code is partially satisfying the expectation.
I am stating the conditions again on which code will decide GOOD or WARNING for Single character Values of column 3 (A, C, E, M, N, P,...

@Don ...I have to answer your questions in blue color.
You have now told us what columns need to be added when column 3 is one of A, C, E, M, N, P, S, SE, or EAMS. And you have told us that column...

---------- Post updated at 12:59 AM ---------- Previous update was at 12:58 AM ----------

@Don... Sorry for numerous updates . Trust me I was just trying to make it as clear as possible and I am...

@Don. Thank you for reading such a long post and your feedback. I tried to edit it.Please let me know if it is readable to you now.Otherwise I will try to edit it more

Input File:-

COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6 SMS Email AO Mail Post N Cell
VEGE Potato E W 396 12 0 384 0 0 0 0 0
VEGE Onion S W 17 0 17 0 0 0 0 0 0
FRUIT APPLE N W 549 61 0 0...

@Ravinder somehow its not working for me however I used Don's solution and it worked.

@Don ...I think I spoke too soon actually I used your code as function and it worked fine ...Thank you so much and I understand what you saying and I understood your code as well ....Thanks one...

@Don ...it worked perfectly and thank you so for sparing time for me and explaining it for me. I am so sorry could not replied on it earlier. I was looking for a function or one liner so that I can...

@Ravinder...Thank you so much I added below to get it tab delimited however I was not able get the header file. As header will be constant in all three files can get the header. Otherwise it worked...

Thank you so much Ravinder for welcoming me and giving the solution. It worked as expected

Two requests
1) could you please let me know if each file has n number of columns for example 32...

there can be n number of columns but the number of columns and header name will remain same in all 3 files. Files are tab Delimited.
a.txt

Name 9/1 9/2
X 1 7
y 2 8
z 3 9
a 4 10
b 5 11
c 6...