Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have data that I am separating into two other columns which I got working:
So I take Failure Mode and break it down into WorkOrder and Reason by adding this to the script:
[Failure Mode] AS [Failure Mode],
subfield([Failure Mode],':',1) AS WorkOrder,
subfield([Failure Mode],':',-1) AS Reason,
But for WorkOrder I only want it to show the WorkOrder number if the failure mode has one. How can I do that?
Thank you!
What I have for Reason is this:
subfield([Failure Mode],':',-1) AS Reason,
That was it, the ':' & that I was missing.
Thank you Sunny