Hello Makers, I’m trying to extract a (single) phone number from a simple string using replace, but can’t wrap my heard around the required regex value to remove all white space and letter characters from the string. Thanks!

@Zbulo That’s much easier. replace(1.string;/(?:.*?((?:1\d{8})|(?:\d{8}))(?:\s|$).*)|.*/;$) Will extract the first 8 contiguous digits or first 9 if the first digit is a 1. Will return nothing if digits are not found. Assumes single line value (no newline characters). If you want a different num…

Text parser for phone numbers (replace, regex)

How To

Michaela Split this topic June 8, 2023, 6:01am 10

2 posts were split to a new topic: Changing ‘item data type’ from ‘text’ to ‘number’

Topic		Replies	Views
REGEX to extract phone number from Text How To regular-expressions	9	5743	September 7, 2023
How can i get numbers from a string? (custom app) How To functions	2	362	September 7, 2023
Need Help with Reformatting a phone number How To	3	1336	September 7, 2023
Replace spaces on text parser string with regex How To functions	5	861	November 6, 2023
Separating (+) from a Phone Number How To	4	627	September 7, 2023

Text parser for phone numbers (replace, regex)

Related Topics