Can anyone help me sort this data out please. I attached a file of the typical data. It consists of three fields: ID Number, Name, DataString. The (cr) signifies the next record. Two records are below. The data is justy one long text string.
....(cr)"429088930","Robert E Watkins ","692026636666",(cr)"206844084","James Thomas ","642036636466",
What i want out is a table of
ID Number Name DataString
Any guidance appreciated.
thanks
Steve
....(cr)"429088930","Robert E Watkins ","692026636666",(cr)"206844084","James Thomas ","642036636466",
What i want out is a table of
ID Number Name DataString
Any guidance appreciated.
thanks
Steve