I receive .txt files daily that I need to import into a table. Each text file contains multiple rows which need to be combined into one row of each table. I am new to this feature and can not seem to figure this out. Example of data:
10|A|B|C|D|E|F|
20|A|B|C|D|E|F|
21|A|B|C|D|E|F|
23|A|B|C|D|E|F|
25|A|B|C|D|E|F|
10|A|B|C|D|E|F|
20|A|B|C|D|E|F|
21|A|B|C|D|E|F|
23|A|B|C|D|E|F|
25|A|B|C|D|E|F| |
Each text file contains starting row records (10, 20, 21, 23, and 25) which all relate to the same "account", where the information follows in each row (A,B,C,D,E,F) Every time a row identifier "10" appears, this tells me where a new "account" begins, which needs to start a new row. The problem is there could be anywhere from 1 through 100 seperate "accounts (record 10) in each text file. I am not sure how to import a file liek this. Thank you in advance for your assistance.