Extracting Parts Of Text

Oh boy I hope you are ready for a little messy and something we have been patching together as we progress. 

The [Billing Summarized] field is created by a long bulky formula to summarize all of the potential billing fields that get entered.  It looks like this (only longer):

If([Physical Therapy Evaluation-Low Complexity Billing]!="",[Physical Therapy Evaluation-Low Complexity Billing] & "\n","")&
If([Physical Therapy Evaluation-Moderate Complexity Billing]!="",[Physical Therapy Evaluation-Moderate Complexity Billing] & "\n","")&
If([Physical Therapy Evaluation-High Complexity Billing]!="",[Physical Therapy Evaluation-High Complexity Billing] & "\n","")&
If([Physical Therapy Re-evaluation Billing]!="",[Physical Therapy Re-evaluation Billing] & "\n","")&
If([Therapeutic Exercise Billing]!="",[Therapeutic Exercise Billing] & "\n","")&
If([Neuromuscular Reeducation Billing]!="",[Neuromuscular Reeducation Billing] & "\n","")&
If([Therapeutic Activity Billing]!="",[Therapeutic Activity Billing] & "\n","")&
If([Gait Training Billing]!="",[Gait Training Billing] & "\n","")&
If([Manual Therapy Billing]!="",[Manual Therapy Billing] & "\n","")&

The fields above are generated from other fields as well that look like this: 

If([Physical Therapy Evaluation-Low Complexity Units]>=1, "97161 Physical Therapy Evaluation-Low Complexity " & [Physical Therapy Evaluation-Low Complexity Units] & " Unit")

You can see I have the actual individual fields already.  The issue is that when we map them with the API there cannot be blanks.   There can be up to 6 lines total on a claim.  So I ultimately need to translate whatever gets billed to Claim 1, Claim 2, Claim 3, Claim 4 etc and we need it to only be the code and the units billed example:

97110 Therapeutic Exercise 1 Unit(s) 

Claim Code 1: 97110

Claim Code 1 Units: 1