Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I don't disagree with the thrust, but I've recently cleaned some of those up.

One example: LLMs aren't smart enough to do things like properly manage zip codes with leading zeros. It was round tripping strings through an integer representation and corrupting them. The users did notice, but did not have the vocabulary/concepts to explain. To them, sometimes zipcodes get corrupted because inscrutable reasons (tm).

chatgpt also authored a bash script that would have blown away a chunk of my drive if any paths had a space in them. :shrug:



Fun thing I noticed is converting a CSV to XLSX in Excel also drops leading 0s from zip codes...


Most spreadsheet software does that because the zips are parsed as integers, not strings . Prefix numerical fields that may contain leading zeros with a non-numerical character/word and save yourself the pain of late discovery! You can just find and replace after it goes in successfully.

Spoken as someone that experienced the same pain years ago in local SEO data that made it way too far before discovery...


You need to select the correct column data format in the Text Import Wizard: https://filestore.community.support.microsoft.com/api/images...




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: