Differentiation between fields values combined with letter and numbers

[Vince_CH]

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. 

[Ivan_Bozov]

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?

[Vince_CH]

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

[Ivan_Bozov · Accepted solution]

Great, then maybe try this:

IF(MATCH(LEFT(YourField, 2), 'R8') OR MATCH(LEFT(YourField, 3), 'R14', 'R15'), 'Yellow', 'Gray') AS YourNewField