Remove data from a string

Help
1

Hi,

I need to remove unwanted data from a string.
/It starts here/
Page 1
Electronic Payments and Statements
ATLANTIC EMERGENCY ASSOC
PO BOX 15356
NEWARK NJ 071925356 Electronic Provider Remittance Advice
Americhoice of New Jersey Inc
PO Box 7550
Phoenix AZ 850117550
Phone: (888) 362-3368
Payment Date: 06/02/2016
TIN: *****7387
NPI: 1760578876
Payment Number: 2016060111600308
Payment Amount: $9,357.94
Account
Number
Patient Name /
Patient ID
Subscriber ID /
Corrected ID
Rendering Provider Claim # /
Claim Type
Group Policy Number
/
Product Name
Date(s) of
Service
Description
of Service
Amount
Charged
Claim /
Service
Adj
Prov Adj
Discount
Amount
Allowed
Deduct/
Coins/
Copay
Paid to
Provider
Adj
Reason
Code
RMK
Code
Patient
Resp
Page 1SA
/ends here/
Subtotal $560.00 $0.00 -$494.00 $66.00 $0.00 $66.00 $0.00
02148453A
MP61201
NADER AWAD/
013093214521
013093214521 16D282182600
05/13/2016-
05/13/2016
HC:99291 $906.00 – -$686.10 $219.90 – $219.90 45 –
05/13/2016-
05/13/2016
HC:93010 $50.00 – -$42.30 $7.70 – $7.70 45 –
Subtotal $956.00 $0.00 -$728.40 $227.60 $0.00 $227.60 $0.00
01028823A
CP98192
DAVID BARABIN/
237012796601
237012796601 16D286749900
04/27/2016-
04/27/2016
HC:99284:
SA
$560.00 – -$512.89 $47.11 – $47.11 45 –
Subtotal $560.00 $0.00 -$512.89 $47.11 $0.00 $47.11 $0.00
02087223A
MP61240
JACQUEL BARNETT/
083007894201
083007894201 16D285283000
05/13/2016-
05/13/2016
HC:99283:
25:SA
$347.00 – -$322.38 $24.62 – $24.62 45 –
05/13/2016-
05/13/2016
HC:10081:
SA
$620.00 – -$579.50 $40.50 – $40.50 45 –
Subtotal $967.00 $0.00 -$901.88 $65.12 $0.00 $65.12 $0.00
02148337A
MP60891
JOSEPH BECKER/
047043189002
047043189002 16D246929600
05/11/2016-
05/11/2016
HC:99283 $347.00 – -$316.51 $30.49 – $30.49 45 –
Subtotal $347.00 $0.00 -$316.51 $30.49 $0.00 $30.49 $0.00
/it starts here/
Page 2
Electronic Payments and Statements
ATLANTIC EMERGENCY ASSOC
PO BOX 15356
NEWARK NJ 071925356 Electronic Provider Remittance Advice
Americhoice of New Jersey Inc
PO Box 7550
Phoenix AZ 850117550
Phone: (888) 362-3368
Payment Date: 06/02/2016
TIN: *****7387
NPI: 1760578876
Payment Number: 2016060111600308
Payment Amount: $9,357.94
Account
Number
Patient Name /
Patient ID
Subscriber ID /
Corrected ID
Rendering Provider Claim # /
Claim Type
Group Policy Number
/
Product Name
Date(s) of
Service
Description
of Service
Amount
Charged
Claim /
Service
Adj
Prov Adj
Discount
Amount
Allowed
Deduct/
Coins/
Copay
Paid to
Provider
Adj
Reason
Code
RMK
Code
Patient
Resp
Page 2
/ends here/

It keeps repeating for every page.
Please help!!

2

May i know whats the output you want to show.
here is the approach
To extract the specific value you need to find the start index and end index of the value and pass these index and get the specific value by using substring
Please refer this with solution .

1 Like
3

Hi,

I want to trim page information from my string as it is unwanted.

4

Sure you can use above solution.