Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Change the field color based on condition in email Post 303031247 by CatchMe on Monday 25th of February 2019 02:27:38 AM
Old 02-25-2019
What operating system are you using? -LINUX
What shell are you using?- bash
What terminal type are you using?- bash
What color do you want to use? RED
Under what condition(s) do you want to use this alternative color? - Here below in coloumn YX, if any value is greaterthan 0, color to YELLOW
Code:
SS|GE|GE|XX|YX
AP|0|0|-1|0
CP|56|0|0|56
CP|0|0|-9|0

What have you tried to accomplish this goal on your own?
Data is available in mariadb, i m selecting data and writing to R.txt separated by | delimiter

I have written below normal printing as table,
Code:
<cat R.txt|awk -F'|' 'BEGIN {print "<!DOCTYPE html><html><body><table border="1" width=75% cellspacing=0> <tr><th bgcolor='"$BGC"'>.....</tr>"}{print "<tr>";
for(i=1;i<=NF;i++)
{
print "<td> "$i"</td>
} />

Is a <tab> character supposed to be the field delimiter in your file? | is the delimter
Why is there a <tab> and a <space> between the XX and YX in the header line in the first line of your output? yes this is header
Why are there a bunch of <space>s instead of a <tab> between the -9 and the 0 in the last line of your output? while copying, spaces been added.
Is your input file in the same format as your output file?input is .txt output i m expecting html and yes, the sequence is same.
Will the YX field always be in the 5th field of your input file? If not how are we supposed to find it? yes it is 5th field




Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules

Last edited by RudiC; 02-25-2019 at 04:27 AM.. Reason: Added CODE tags.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Convert::Color(3pm)					User Contributed Perl Documentation				       Convert::Color(3pm)

NAME
"Convert::Color" - color space conversions and named lookups SYNOPSIS
use Convert::Color; my $color = Convert::Color->new( 'hsv:76,0.43,0.89' ); my ( $red, $green, $blue ) = $color->rgb; # GTK uses 16-bit values my $gtk_col = Gtk2::Gdk::Color->new( $color->as_rgb16->rgb16 ); # HTML uses #rrggbb in hex my $html = '<td bgcolor="#' . $color->as_rgb8->hex . '">'; DESCRIPTION
This module provides conversions between commonly used ways to express colors. It provides conversions between color spaces such as RGB and HSV, and it provides ways to look up colors by a name. This class provides a base for subclasses which represent particular color values in particular spaces. The base class provides methods to represent the color in a few convenient forms, though subclasses may provide more specific details for the space in question. For more detail, read the documentation on these classes; namely: o Convert::Color::RGB - red/green/blue as floats between 0 and 1 o Convert::Color::RGB8 - red/green/blue as 8-bit integers o Convert::Color::RGB16 - red/green/blue as 16-bit integers o Convert::Color::HSV - hue/saturation/value o Convert::Color::HSL - hue/saturation/lightness o Convert::Color::CMY - cyan/magenta/yellow o Convert::Color::CMYK - cyan/magenta/yellow/key (blackness) The following classes are subclasses of one of the above, which provide a way to access predefined colors by names: o Convert::Color::VGA - named lookup for the basic VGA colors o Convert::Color::X11 - named lookup of colors from X11's rgb.txt CONSTRUCTOR
$color = Convert::Color->new( STRING ) Return a new value to represent the color specified by the string. This string should be prefixed by the name of the color space to which it applies. For example rgb:RED,GREEN,BLUE rgb8:RRGGBB rgb16:RRRRGGGGBBBB hsv:HUE,SAT,VAL hsl:HUE,SAT,LUM cmy:CYAN,MAGENTA,YELLOW cmyk:CYAN,MAGENTA,YELLOW,KEY vga:NAME vga:INDEX x11:NAME For more detail, see the constructor of the color space subclass in question. METHODS
( $red, $green, $blue ) = $color->rgb Returns the individual red, green and blue color components of the color value. For RGB values, this is done directly. For values in other spaces, this is done by first converting them to an RGB value using their "to_rgb()" method. COLOR SPACE CONVERSIONS
Cross-conversion between color spaces is provided by the "convert_to()" method, assisted by helper methods in the two color space classes involved. When converting $color from color space SRC to color space DEST, the following operations are attemped, in this order. SRC and DEST refer to the names of the color spaces, e.g. "rgb". 1. If SRC and DEST are equal, return $color as it stands. 2. If the SRC space's class provides a "convert_to_DEST" method, use it. 3. If the DEST space's class provides a "new_from_SRC" constructor, call it and pass $color. 4. If the DEST space's class provides a "new_rgb" constructor, convert $color to red/green/blue components then call it. 5. If none of these operations worked, then throw an exception. These functions may be called in the following ways: $other = $color->convert_to_DEST() $other = Dest::Class->new_from_SRC( $color ) $other = Dest::Class->new_rgb( $color->rgb ) $other = $color->convert_to( $space ) Attempt to convert the color into its representation in the given space. See above for the various ways this may be achieved. If the relevant subclass has already been loaded (either explicitly, or implicitly by either the "new" or "convert_to" methods), then a specific conversion method will be installed in the class. $other = $color->as_$space Methods of this form are currently "AUTOLOAD"ed if they do not yet exist, but this feature should not be relied upon - see below. AUTOLOADED CONVERSION METHODS
This class provides "AUTOLOAD" and "can" behaviour which automatically constructs conversion methods. The following method calls are identical: $color->convert_to('rgb') $color->as_rgb The generated method will be stored in the package, so that future calls will not have the AUTOLOAD overhead. This feature is deprecated and should not be relied upon, due to the delicate nature of "AUTOLOAD". OTHER METHODS
As well as the above, it is likely the subclass will provide accessors to directly obtain the components of its representation in the specific space. For more detail, see the documentation for the specific subclass in question. SUBCLASS METHODS
This base class is intended to be subclassed to provide more color spaces. $class->register_color_space( $space ) A subclass should call this method to register itself as a named color space. $class->register_palette( %args ) A subclass that provides a fixed set of color values should call this method, to set up automatic conversions that look for the closest match within the set. This conversion process is controlled by the %args: enumerate => STRING or CODE A method name or anonymous CODE reference which will be used to generate the list of color values. enumerate_once => STRING or CODE As per "enumerate", but will be called only once and the results cached. This conversion process only finds the closest match in RGB space, so it may not give exact results. In the case of a tie, where two or more colors have the same distance from the target, the first one will be chosen. AUTHOR
Paul Evans <leonerd@leonerd.org.uk> perl v5.12.3 2011-06-15 Convert::Color(3pm)
All times are GMT -4. The time now is 10:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy