Separating Data

[hammermill21]

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!

[hammermill21]

What I have for Reason is this:

subfield([Failure Mode],':',-1) AS Reason,

[hammermill21]

That was it, the ':' & that I was missing.

Thank you Sunny