Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to tag back the data of workorder_Inner with R_WORK_LOT ignoring the last 3 characters
Hi
If you want to ignore the last 3 character, try like below.. its one of the way
=Left(R_WORK_LOT, Len(R_WORK_LOT )-4)
Hi
Can you share an example out of what you are trying to achieve as i am not sure what you mean by tag back.
My best guess would be a Concat something like the Below
workorder_Inner &'+'&LEFT(R_WORK_LOT, LEN(R_WORK_LOT )-3) AS "New field"
No, I need data that the last 3 digits are not -000
No, I need data that the last 3 digits are not -000
Are you looking some thing like below
if(right(R_WORK_LOT,3) <> '000', R_WORK_LOT)