nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

RegEx Question

XxparsegodxX

Hi Alteryx Community!

I am currently using the following RegEx expression to extract only words. I.e. to take out groupings of words until the phrase hits a digit. (\D+)

Input: Example (Example) Text ($M) (7) 235,547 225,788 218,227 4 8

However, the RegEx doesn't work when there is an unwanted brackets number i.e. the (7)

Current Output: Assets Under Management (AUM) - average ($M) (

Desired Output: Assets Under Management (AUM) - average ($M)

I then use a Right & Length formula to extract the numbers from the cell.

Let me know if any of the above doesn't make sense and I can help clarify...thanks everyone!! (first time posting on alteryx community so super excited )

Regex

Accepted answers

fmvizcaino

Hi @XxparsegodxX ,

For that, I think you can use the following regular expression: ([^\d]+)\s.*?\d

Best,

Fernando Vizcaino

All comments

estherb47

Hi @XxparsegodxX

Your RegEx statement is working, in that it's stopping as soon as it finds a digit, which is after the open parenthesis.

Does the rest of your data follow the same pattern? That is, numbers in brackets followed by groups of numbers? If so, I'd use a Formula tool with the following 2 expressions: