Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello friends,
I have a list of field values like below, I want to differentiate the yellow values from the grey ones, how shall the scripts or expressions should like? thanks in advance for the help.
Great, then maybe try this:
IF(MATCH(LEFT(YourField, 2), 'R8') OR MATCH(LEFT(YourField, 3), 'R14', 'R15'), 'Yellow', 'Gray') AS YourNewField
I suppose this is not your full list, so what exactly differentiates these values? Do they always begin with R1 or R8? Is the length always 7 or 10 characters? Is it something else?
Hello Ivan, you gave me some hints here.
yes the yellow marked field value always starts with R8, or R14 or R15, so can i write like this in the scripts?
If (left(filedvalue,2)='R8' or left(filedvalue,3)={'R14' ,'R15'}, filedvalue) as YELLOW,
Best regards!
Vincent
Great, then maybe try this:
IF(MATCH(LEFT(YourField, 2), 'R8') OR MATCH(LEFT(YourField, 3), 'R14', 'R15'), 'Yellow', 'Gray') AS YourNewField