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)

Questions & Answers

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 Questions & Answers regular-expressions	9	4005	September 7, 2023
How can i get numbers from a string? (custom app) Questions & Answers functions	2	263	September 7, 2023
Need Help with Reformatting a phone number Questions & Answers	3	939	September 7, 2023
Replace spaces on text parser string with regex Questions & Answers functions	5	566	November 6, 2023
Separating (+) from a Phone Number Questions & Answers	4	467	September 7, 2023

Text parser for phone numbers (replace, regex)

Related Topics