Text file has no line breaks - how do I parse this?
What is the best way to deal with content that is a big block of text without line breaks? Is there a way to add line breaks prior to creating a trap?
Also, the report uses the the pipe as a deliminator and is poorly formatted for data mining.
There appear to be two ways the data is displayed:
Alpha-numeric Record Name | Unknown | Account # | Account Type | Name | email address | Unknown | Reason for return
or
Numeric | Account # | Account Type | Name | email address | unknown | Reason for return
But in order to work with the fuzzy data, I really need some line breaks first - any ideas on an approach would be greatly appreciated!
Rebekah
------------------------------
Rebekah
Operational Risk Analyst
Exchange Bank (CA)
------------------------------
Also, the report uses the the pipe as a deliminator and is poorly formatted for data mining.
There appear to be two ways the data is displayed:
Alpha-numeric Record Name | Unknown | Account # | Account Type | Name | email address | Unknown | Reason for return
or
Numeric | Account # | Account Type | Name | email address | unknown | Reason for return
But in order to work with the fuzzy data, I really need some line breaks first - any ideas on an approach would be greatly appreciated!
Rebekah
------------------------------
Rebekah
Operational Risk Analyst
Exchange Bank (CA)
------------------------------