Need formulas to extract data based on special characters

I need formulas to extract some data from a barcode scan based on a special character in the barcode data. The barcode data contains:
{Work Order}_{Roll}_{Arbor}_{Part Number}_{Date}_{Qty}

Here is what a typical barcode looks like when it is decoded to legible text:
50045784_35_12_ AC20438400TB008_120514_16.00

However, some barcodes decode like this:
___NA02188360AA000_111414_25.00 (three leading underscores as these parts do not have work orders, rolls or arbors.)

or this:
50046927___RF05063510GE000_043015_386.00 (three underscores between the work order and the part number since these parts have no roll or arbor)



For inventory purposes, I need to extract to three separate cells the part number the date and the qty:
AC20438400TB008 120514 16.00
NA02188360AA000 111414 25.00
RF05063510GE000 043015 386.00

Can anybody help me with the formulas I need?

oeldere,

My apologies. I was in the process of creating a few sample rows in a spreadsheet to attach when I saw nflsales reply. His response solved my problem.

nflsales,

Thank you so much! That was exactly what I needed. It worked with any configuration I threw at it. I did leave off the "+0" on the third formula as I do need the two decimals.