I have a large volume of text files that are XML based, but need to be cleaned as have 1 to 3 lines of garbage at the top of them, preventing me from performing ETL as my ultimate goal is to get these in a SQL server DB.
Here is an example of the first 3 lines of one:
ÜTïx Hh 6
Default Table<
å ...
Search found 1 match
- Fri Jan 22, 2021 3:53 am
- Forum: Regular Expressions (Archived)
- Topic: Dot Matches Newline ---- Not Working as Expected
- Replies: 1
- Views: 23890