Tag: alphanumeric

SQL – Extracting first 5 consecutive numbers from alphanumeric string

I am using AWS Athena, so functions are a bit limiting. But essentially I want to extract the first 5 consecutive and sequential numbers from a alphanumeric field. From the first example, you can see it ignores the first 1 because there aren’t 4 trailing numbers. I want to find and extract the first 5 numbers that are given together

Splitting alphumeric column in SQL

alphanumeric database replace split sql

I currently have a dataset looking like this J_J WMT MSF 6.7M 167.8M 1.6k 544K 700.7B 875k 888.7B 900K 98.5M I want to split the string values for each column so …