Posts

AI task test, data cleaning

 Well, so much for AI extracting information from e-mails. This is why I have my doubts about AI. I'm using Gmail Cloud HQ to separate out my mainly LinkedIn (with some other items) job search from all the spam I get. I'm then pushing that into an Azure SQL database. Using three separate queries looking for "%appli%" from "noreply@" in Gmail (because GMAIL doesn't actually support wildcards) I'm pulling in three slightly different CSV files into SQL, cleaning them, and putting them into my job search. This is *AFTER* CloudHQ used "AI parsing" to fill certain fields to begin with. Here's the script: /****** Object: Table [dbo].[CombinedCleand]  Script Date: 7/22/2025 10:59:29 AM ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CombinedCleand]') AND type in (N'U')) DROP TABLE [dbo].[CombinedCleand] GO /****** Object: Table [dbo].[CombinedCleand]  Script Date: 7/22/2025 10:59:29 AM ***...