Hello,
I have a field that downloads out of my system with the following data. I created a formula, =IFERROR(MID(Q5,FIND("Quantity:",Q5)+10,-FIND("Quantity:",Q5)+2),"") which works fine if there is only one number after the Quantity, but as you can see there can be times that there are more. Once i get that number, i multiply it by a cost. I can't do that with a 2 or more digit result as it will then put in a space. Any suggestions?
<tbody>
</tbody>
Or
<tbody>
</tbody>
I have a field that downloads out of my system with the following data. I created a formula, =IFERROR(MID(Q5,FIND("Quantity:",Q5)+10,-FIND("Quantity:",Q5)+2),"") which works fine if there is only one number after the Quantity, but as you can see there can be times that there are more. Once i get that number, i multiply it by a cost. I can't do that with a 2 or more digit result as it will then put in a space. Any suggestions?
Quantity: 1||Location: 8010-8013-8017||Inventory Status: Issued for Use|| Result = 1 |
<tbody>
</tbody>
Or
Quantity: 400|| Result = 4 |
<tbody>
</tbody>