Billing code search on in-network-rates file. Steps: 1. Retrieve compressed-datasource file via wget. around 2-5 mins. 2. Expand/uncompressed datasource file via gunzip. around 10-20 mins. 3. Search for billing-code on datasource file via fgrep. around 1 min. Example Steps. 1. Retrieve compressed-datasource file (3.5 G) via wget. wget https://mrfmftprod.bcbsnc.com/prod/etl/outbound/in-network-rates/2022-11-15_Preferred-Provider-Network_B00000000001_in-network-rates.json.gz 2. Expand/uncompressed datasource file via gunzip (from 3.5 G to 112 G). gunzip 2022-11-15_Preferred-Provider-Network_B00000000001_in-network-rates.json.gz 3. Search for billing_code on datasource file via fgrep I. Usage: fgrep -l '"billing_code":"YYY"' XXX.json XXX - json filename YYY - billing code number Example: fgrep -l '"billing_code":"100"' 2023-01-16_State-Health-Plan-Network_BSHP10000001_in-network-rates.json IF fgrep finds billing-code in file, then it displays file again. IF fgrep does not find billing-code in file, then it display blank. Example with time metric command: ``` ### Example with fgrep finding a billing code in file, by showing filename again chriscalip@raptor:~/projects/php/bigquery$ time fgrep -l '"billing_code":"100"' /media/chriscalip/easystore/ths/xmain/2023-01-16_State-Health-Plan-Network_BSHP10000001_in-network-rates.json /media/chriscalip/easystore/ths/xmain/2023-01-16_State-Health-Plan-Network_BSHP10000001_in-network-rates.json real 0m41.994s user 0m7.241s sys 0m18.599s ### Example with fgrep not finding a billing code in file, shows nothing. chriscalip@raptor:~/projects/php/bigquery$ time fgrep -l '"billing_code":"FAKE-CODE"' /media/chriscalip/easystore/ths/xmain/2023-01-16_State-Health-Plan-Network_BSHP10000001_in-network-rates.json real 0m15.648s user 0m7.598s sys 0m8.021s ```