Extracting Data from ERP Database based on 2 variables in Spreadsheet...cont'd

... funny because it seems to work as is.....

Should I just change using something like:

TRIM(MID(c.Value,FIND("^^",SUBSTITUTE(c.Value,"-","^^",LEN(c.Value)-LEN(SUBSTITUTE(c.Value,"-",""))))+1,3))

I did try that, and not surprisingly... didn't work.