I have a interesting file that I want to read in. I would like to know if there's a way to read in this kind of file.... Here's a few lines from the file. You'll see that there are spaces, empty lines and data in various formats with different number of columnsm types and lengths.
Account Pricing Plan List Mapping
=================================
Import Account Pricing Plan List Map To Account Pricing Plan List
Subscriber Pricing Plan List Mapping
====================================
Import Subscriber Pricing Plan List Map To Subscriber Pricing Plan List
500 VC:Plan 500 (Per Sec)
REQ VC:Plan Frequent (Per Min)
CDR Pricing Plan List Mapping
=============================
Import CDR Pricing Plan List Map To CDR Pricing Plan List
Call Type Mapping
=================
Import Call Type Map To Call Type
ROA Roaming
SPE Services
MOB Cell. to Cell.
NAT National
SubType Mapping
===============
Import SubType (1) Import SubType (2) Map To SubType
ROA ANY ANY
SPE 121 121
MOB VOD VOD
NAT LOC LOC
MOB MTN MTN
INT 905 905
SPE SMS SMS
SPE GEN GEN
INT 904 904
NAT LON LON
I am interested in the data in the following sections only:
1. Subscriber Pricing Plan List Mapping.
2. Call Type Mapping.
3. SubType Mapping.
Or read as varchar, check for first few digits for "Subscriber" or "Call" or 'Sub" and based on it you can divert it into different stream.
And ignore the first 2 lines.
And this should be done untill an empty space. Guess it is the end of that paragraph.
You can use stage variable and flag for this to accomplish.
Or simply use routines or any scripts for this.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'