René's URL Explorer Experiment


Title: fix(tables): keep leading-zero codes as text when inferring CSV column types by waleedlatif1 · Pull Request #9754 · simstudioai/sim · GitHub

Open Graph Title: fix(tables): keep leading-zero codes as text when inferring CSV column types by waleedlatif1 · Pull Request #9754 · simstudioai/sim

X Title: fix(tables): keep leading-zero codes as text when inferring CSV column types by waleedlatif1 · Pull Request #9754 · simstudioai/sim

Description: Summary CSV import inferred a column as number whenever every sampled value parsed with Number(), so ZIP codes, phone numbers, and SKUs like 02134 were stored as 2134 and the leading zero was lost for good inferColumnType now treats a value with a leading zero followed by another digit as text; 0, 0.5, and -0.5 still infer as numbers Covers new-table imports and new columns added during an append import (both use the same inference) Type of Change Bug fix Testing Regression test in lib/table/import.test.ts, shown red on the pre-fix code, green after lib/table/import.test.ts + lib/table/import-runner.test.ts pass (47 tests) biome on changed files; full type-check/audits left to CI Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing (new tests pass the test-audit authoring gate) No new warnings introduced I confirm that I have read and agree to the terms outlined in the Contributor License Agreement (CLA)

Open Graph Description: Summary CSV import inferred a column as number whenever every sampled value parsed with Number(), so ZIP codes, phone numbers, and SKUs like 02134 were stored as 2134 and the leading zero was lost...

X Description: Summary CSV import inferred a column as number whenever every sampled value parsed with Number(), so ZIP codes, phone numbers, and SKUs like 02134 were stored as 2134 and the leading zero was lost...

Opengraph URL: https://github.com/simstudioai/sim/pull/9754

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:0dc05726-73c2-4f04-78d6-07d29886cc1d
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idE96E:29D5DB:1DF0E14:28A77A2:6AFB9F0D
html-safe-nonce8cf7e252c749f783a392c6050c167f72ab968bc85f534ab59fd88f2d73f4ff7f
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFOTZFOjI5RDVEQjoxREYwRTE0OjI4QTc3QTI6NkFGQjlGMEQiLCJ2aXNpdG9yX2lkIjoiMzMyNTY4NTEyMTQ1MjU4MDYyMSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac5826ed57381bb03c55f73dc786028cca99b27654b2db9412d8aa9f602e28d4c9
hovercard-subject-tagpull_request:5194275990
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/simstudioai/sim/pull/9754/files
twitter:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
og:image:altSummary CSV import inferred a column as number whenever every sampled value parsed with Number(), so ZIP codes, phone numbers, and SKUs like 02134 were stored as 2134 and the leading zero was lost...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None3cefd19a936819d82cfb5279d50fb56fe79cb9ec30f0f807e04e89b0c58ffae1
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/simstudioai/sim git https://github.com/simstudioai/sim.git
octolytics-dimension-user_id199344406
octolytics-dimension-user_loginsimstudioai
octolytics-dimension-repository_id912559512
octolytics-dimension-repository_nwosimstudioai/sim
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id912559512
octolytics-dimension-repository_network_root_nwosimstudioai/sim
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release606800bdb1b81d125fc845bdcc262c9fe063fc8f
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/9754/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F9754%2Ffiles
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F9754%2Ffiles
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=simstudioai%2Fsim
Reloadhttps://github.com/simstudioai/sim/pull/9754/files
Reloadhttps://github.com/simstudioai/sim/pull/9754/files
Reloadhttps://github.com/simstudioai/sim/pull/9754/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests199 (199)https://github.com/simstudioai/sim/pulls
Actionshttps://github.com/simstudioai/sim/actions
Projectshttps://github.com/simstudioai/sim/projects
Security and qualityhttps://github.com/simstudioai/sim/security
Insightshttps://github.com/simstudioai/sim/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
waleedlatif1https://github.com/waleedlatif1
staginghttps://github.com/simstudioai/sim/tree/staging
fix/csv-import-leading-zerohttps://github.com/simstudioai/sim/tree/fix/csv-import-leading-zero
Conversation 2 https://github.com/simstudioai/sim/pull/9754
Commits 1 https://github.com/simstudioai/sim/pull/9754/commits
Checks 80 https://github.com/simstudioai/sim/pull/9754/checks
Files changed https://github.com/simstudioai/sim/pull/9754/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9754/files
fix(tables): keep leading-zero codes as text when inferring CSV column types https://github.com/simstudioai/sim/pull/9754/files#top
Show all changes 1 commit https://github.com/simstudioai/sim/pull/9754/files
16bd9c7 fix(tables): keep leading-zero codes as text when inferring CSV colum… waleedlatif1 Nov 6, 2026 https://github.com/simstudioai/sim/pull/9754/commits/16bd9c7d93d73116962d7a771d33c68b519a3534
Clear filters https://github.com/simstudioai/sim/pull/9754/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9754/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/9754/files
import.test.ts https://github.com/simstudioai/sim/pull/9754/files#diff-0ee513c4fdfad36c9fddadd81bf3712e6f29da25c25687e9d69cc71361f5bcdd
import.ts https://github.com/simstudioai/sim/pull/9754/files#diff-cb562762d3e5bbf1b12771d80f70144c6aeaa65833c1d3f61872ffc948506f43
apps/sim/lib/table/import.test.tshttps://github.com/simstudioai/sim/pull/9754/files#diff-0ee513c4fdfad36c9fddadd81bf3712e6f29da25c25687e9d69cc71361f5bcdd
View file https://github.com/simstudioai/sim/blob/16bd9c7d93d73116962d7a771d33c68b519a3534/apps/sim/lib/table/import.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9754/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9754/files#diff-0ee513c4fdfad36c9fddadd81bf3712e6f29da25c25687e9d69cc71361f5bcdd
https://github.com/simstudioai/sim/pull/9754/files#diff-0ee513c4fdfad36c9fddadd81bf3712e6f29da25c25687e9d69cc71361f5bcdd
apps/sim/lib/table/import.tshttps://github.com/simstudioai/sim/pull/9754/files#diff-cb562762d3e5bbf1b12771d80f70144c6aeaa65833c1d3f61872ffc948506f43
View file https://github.com/simstudioai/sim/blob/16bd9c7d93d73116962d7a771d33c68b519a3534/apps/sim/lib/table/import.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/9754/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/9754/files#diff-cb562762d3e5bbf1b12771d80f70144c6aeaa65833c1d3f61872ffc948506f43
https://github.com/simstudioai/sim/pull/9754/files#diff-cb562762d3e5bbf1b12771d80f70144c6aeaa65833c1d3f61872ffc948506f43
Please reload this pagehttps://github.com/simstudioai/sim/pull/9754/files
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.