2 of 2 people found this helpful
You can use the following:
IF MID([Field Name],4,1) = 'N' THEN 'Nominate'
ELSEIF MID([Field Name],4,1) = 'I' THEN 'Invest'
ELSEIF MID([Field Name],4,1) = 'B' THEN 'Batch'
Also can you please help me here?
I want to find the time slice for a Date&Time column called it as "Order Date" for the value
0-100 ms, 101-200 ms, 201-300 ms ... 900ms-1 second, 1.1-2 second, 2.1-3 sec ... > 4 sec
Can you please provide a little bit more information? If possible a sample of the data you are trying to slice?