Hi everyone. I am trying to use regular expression to extract numerical values from a conversation and store them separately into different columns in google sheets but I am only able to get the correct output for PROD. See below example: Step1: Conversation: "Hi. I would like to order PROD12345 w…

[image] Jose_H: PROD(.\d)+ Try something like this instead, (?<=PROD)\d+

Regular Expression for numerical values

Runcorn May 19, 2023, 11:30am 2

Try something like this instead,

(?<=PROD)\d+

2 Likes

Topic		Replies	Views
How to extract specific text from the value? Getting Started regular-expressions	6	2509	September 7, 2023
Need help with Regex statement for multiple date formats How To google-sheets	6	45	October 30, 2024
Help with Google Sheets formula REGEX_EXTRACT pattern How To airtable , regular-expressions	3	293	April 15, 2024
Extract phone number from google calendar description Getting Started google-calendar	8	689	October 11, 2023
Need to extract information from a email messages . Need help with the regex pattern /expression How To google-sheets , text-parser	14	456	October 7, 2024