Unanswered

How to Extract Consecutive Text and Numbers Using AI Builder?

(0) Share

Report

Posted on by JS-30101525-0

I'm working on a project where I need to separate text and numbers that are grouped together in a single string, using AI Builder. For example, given the input:

Input: "Abc123"
Expected Output:
Text: "Abc"
Number: "123"

Categories:

AI Builder

I have the same question (0)

All responses (2)

Answers (1)

takolota1 4,974 Moderator on at

Like (0)

Report

You may be better off asking / searching “how to split on letter to number changes in Power Automate”
Or find a Regex solution.

Was this reply helpful? Yes No
Verified answer

rixmcx59 158 on at

Like (0)

Report

hello, I solved a similar problem using Chunk(), my string looked like this "777,777,777 possible". AI builder would select the number and the space and the text.

Try tagging the string for both values documentNo and textOfTotal with the string then extract the text with substring() and the number with Chunk().

I was able to do this in my test, but I need to know if the number always starts with 1 or can it start with any integer.

Was this reply helpful? Yes No