Forum Discussion
Solved
Complicated Automation Help - 11.5 million records to process!
Hi, I’ve got a ton of data to process ie. 23 files with 500,000 rows each - the whole public Companies House People with Significant Control database basically. The files are .txt files where all...
Please check if there is confidential data in your post and remove all confidential data.
=MID(A2,SEARCH("company_number",A2)+17,8)=MID(A2,SEARCH("year",A2)+6,4)If all the records have the same pattern you can try these formulas which are in cells B2 and C2 in the screenshot. The formulas can be filled down as required.
Please check if there is confidential data in your post and remove all confidential data.
=MID(A2,SEARCH("company_number",A2)+17,8)=MID(A2,SEARCH("year",A2)+6,4)If all the records have the same pattern you can try these formulas which are in cells B2 and C2 in the screenshot. The formulas can be filled down as required.
- Thanks, as the response below this is publicly available. Thanks for suggesting the formulas - the first one worked but unfortunately the second one didn't - I think because the records don't have all the fields so sometimes "year" can be the 8th field of data and sometimes the 10th for eg.
- Sorry, I have got your second formula to work - it just didn't have a year in the first record which is why I had the error! Thank you so much!
