Change the field color based on condition in email


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Change the field color based on condition in email
# 15  
Old 02-25-2019
Hi Rudic, Thanks for your swift response and my code moved further after your suggestion.
It is working very perfect if the value is not comma separated.
# 16  
Old 02-25-2019
Quote:
Originally Posted by CatchMe
Hi Rudic, Thanks for your swift response and my code moved further after your suggestion.
It is working very perfect if the value is not comma separated.
Hi CatchMe,
I'm not sure what this means.

Are you saying your problem is resolved?

Or, are you saying that the modifications you have made to the code RudiC gave you don't work when the number given in field #5 is larger than 999? If the code doesn't work in this case are we to assume (since you haven't shown us the changes you made to the code nor supplied your new sample input format) that you do not want our help in fixing your remaining problems?

Last edited by Don Cragun; 02-25-2019 at 04:15 PM..
These 2 Users Gave Thanks to Don Cragun For This Post:
# 17  
Old 02-25-2019
Hi Don and Rudic, Thanks for your super help .. yes it is working, here is how I am using to achieve my desired output and it is working irrespective of input in any format.
Code:
<col="bgcolor=RED"
{print "<tr>";
for(i=0;i<=NF;i++)
print "<td "((i==5 && $i!=0)?Col:"") " aligin='"right"'>"$i"</td>";
print "</tr>} />

Thanks again for your super support!!

Last edited by Don Cragun; 02-26-2019 at 12:14 AM.. Reason: Add missing CODE tags again.
# 18  
Old 02-26-2019
Quote:
Originally Posted by CatchMe
Hi Don and Rudic, Thanks for your super help .. yes it is working, here is how I am using to achieve my desired output and it is working irrespective of input in any format.
Code:
<col="bgcolor=RED"
{print "<tr>";
for(i=0;i<=NF;i++)
print "<td "((i==5 && $i!=0)?Col:"") " aligin='"right"'>"$i"</td>";
print "</tr>} />

Thanks again for your super support!!
Hi CatchMe,
I admit that I had trouble keeping up with your changing requirements. I was looking forward to seeing what you had come up with to solve your problem. But, now that I see your code, I'm even more confused. I have no idea what the < is doing on the first line your code.

And using the remainder of that line as a condition instead of as an assignment in a BEGIN clause means that every input line will be written out in its entirety without HTML table processing??? I don't see how that fits into any of the output formats you said you wanted to produce.

With the for loop starting with i set to zero instead of one, the entire input line will again be displayed as the first output column in your table. That clearly won't match any of the output you said you want to produce???

Am I correct in assuming that aligin was intended to be align?

I had originally assumed that the right in this line was intended to be literal text specifying the alignment, but since the single-quotes on this line are inside double-quoted strings, the right appears to be the name of a variable that has no assigned value in the code you have shown us??? Has it been assigned a value somewhere that you haven't shown us?

The last print statement has an unterminated double-quoted string.

And, there is the extraneous /> at the end of your code fragment (or is that part of the unterminated string that is being printed)?

I'm glad that you have code that is working for you, but I don't understand how the code shown above produces anything similar to any of the output you said you want to produce.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple... (15 Replies)
Discussion started by: cotilloe
15 Replies

2. Shell Programming and Scripting

awk to change contents of field based on condition in same file

In the awk below I am trying to copy the entire contents of $6 there may be multiple values seperated by a ;, to $8, if $8 is . (lines 1 and 3 are examples). If that condition $8 is not . (line2 is an example) then that line is skipped and printed as is. The awk does execute but prints the output... (3 Replies)
Discussion started by: cmccabe
3 Replies

3. Shell Programming and Scripting

Help with awk color codes based on condition

HI i have two files say test and test1 Test.txt Code: Lun01 2TB 1.99TB 99.6% Lun02 2TB 1.99TB 99.5% Lun03 2TB 1.99TB 99.5% Lun04 2TB 1.55TB 89.6% Code: Test1.txt Lun01 2TB 1.99TB 89.5% Lun02 2TB 1.99TB 99.5% Lun03 2TB 1.99TB 99.5% Requirement is to compare... (6 Replies)
Discussion started by: venkitesh
6 Replies

4. Shell Programming and Scripting

How to change the color inside email using shell script?

hi, i want to send an email from unix using mailx command. mailx -s "subject" "email@abc.com" < email.txt Email.txt contains some file names that are transferred successfully and some that failed. so the files that got failed to tranfer, should be displayed in red color in the mail. is it... (1 Reply)
Discussion started by: Little
1 Replies

5. UNIX for Dummies Questions & Answers

How to change the background color in the init 3 mode(not line color)

Hello, I am using RHEL 6.1 on VMware I am searching for a way to change background color (not line by line color wich one can using tput command) basically changing the color of the whole screen to white instead of the default black and changing font color to black and alos would like to... (2 Replies)
Discussion started by: Dexobox
2 Replies

6. Shell Programming and Scripting

Color line based on first field

Hello, I have a bash script that outputs the following text to a file and then prints that file to the screen: |64 |30 |0 |8 |23:59:14 |38 |57 |2 |14 |00:09:05 |29 |50 |4 |20 |23:58:04 |20 |48 |7 |23 |00:05:44 |18 ... (2 Replies)
Discussion started by: fnj00
2 Replies

7. Shell Programming and Scripting

How can I change file value based on condition

Hi, Gurus, I got a problem to resolve following issue: I have one file file1as following: start_dt=2010-01-01 12:00:02 start_dt=2011-01-01 09:00:02 start_dt=2009-01-01 11:00:02I have another file file2 as following: title1, 2010-01-03 10:00:02 title2, 2011-01-04 11:00:02 title3,... (5 Replies)
Discussion started by: ken002
5 Replies

8. Shell Programming and Scripting

Help with Awk finding and replacing a field based on a condition

Hi everybody, I'm trying to replace the $98 field with "T" if the last field (108th) is T I've tried awk 'BEGIN{OFS=FS="|"} {if ($108=="T")sub($98,"T"); print}' test.txt but that doesn't do anything also tried awk 'BEGIN{OFS=FS="|"}{ /*T.$/ sub($98,"T")} { print}' test.txt but... (2 Replies)
Discussion started by: jghi123
2 Replies

9. Shell Programming and Scripting

Update a field in a file based on condition

Hi i am new to scripting. i have a file file.dat with content as : CONTENT_STORAGE PERCENTAGE FLAG: /storage_01 64% 0 /storage_02 17% 1 I need to update the value of FLAG for a particular CONTENT_STORAGE value I have written the following code #!/bin/sh threshold=20... (1 Reply)
Discussion started by: kichu
1 Replies

10. Shell Programming and Scripting

Change in Input feed based on condition file

Sorry Guys for not being able to explain in one of my earlier post. I am now putting my requirement with the input file and desired output file. In the below input file - Transaction code is at position 31:40. Business code is from position 318:321 TSCM00000005837 ... (7 Replies)
Discussion started by: varunrbs
7 Replies
Login or Register to Ask a Question