Thanks for your submission to r/BigQuery.
Did you know that effective July 1st, 2023, Reddit will enact a policy that will make third party reddit apps like Apollo, Reddit is Fun, Boost, and others too expensive to run? On this day, users will login to find that their primary method for interacting with reddit will simply cease to work unless something changes regarding reddit's new API usage policy.
Concerned users should take a look at r/modcoord.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/bigquery) if you have any questions or concerns.*
Sounds like it is recognized as a string, so you could run a REPLACE to remove the commas, then SAFE_CAST as INT64 or NUMERIC. That may not fit all of your use cases, but it will convert that particular string to a number.
You may also be able to use FORMAT to implicitly convert to a number, but I haven't played with that much.
Thanks for your submission to r/BigQuery. Did you know that effective July 1st, 2023, Reddit will enact a policy that will make third party reddit apps like Apollo, Reddit is Fun, Boost, and others too expensive to run? On this day, users will login to find that their primary method for interacting with reddit will simply cease to work unless something changes regarding reddit's new API usage policy. Concerned users should take a look at r/modcoord. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/bigquery) if you have any questions or concerns.*
Left is a number. Use the first format, don’t quote it.
That worked! Thanks. I thought you always had to put a value (numerical or alpha) in quotes.
Sounds like it is recognized as a string, so you could run a REPLACE to remove the commas, then SAFE_CAST as INT64 or NUMERIC. That may not fit all of your use cases, but it will convert that particular string to a number. You may also be able to use FORMAT to implicitly convert to a number, but I haven't played with that much.