Filter or Remove Unwanted Letters or Characters Leaving Data in Row

[sslattery17]

My input source has a column with primary name and/or residents.  The client sometimes uses designations (H) or (H) Shannon**Slattery** to identify the tenants unit type etc...I have tried to filter this out a few different ways including using regex_replace([Residents],"[^\sa-zA-Z]",'') or regex_replace ([Residents],"(H)",'')  I need the tenant name to stay but any and all designations to be removed.  I even tried the find replace and that did not work as expected.  I have attached screenshots.  With 6 weeks into the use of this tool; any guidance suggestions, would greatly be appreciated.  

  

[binuacs]

@sslattery17 @What is the expected result using this formula?

[ChrisTX]

That is not the right format for a Regex_Replace function.   you have an extra right parenthesis, but even if you fix that the function structure is not right.

Look at the examples on the Functions page.

REGEX_Replace(String, pattern, replace, icase): Allows replacement of text using regular expressions and returns the string resulting from the RegEx find (pattern) and replace (string). All occurrences of the match are replaced, not just the first.

The replace parameter can be either a specified value as shown below or a marked group, like "$1". Make sure that marked groups are wrapped in double quotes.

icase is an optional parameter. When specified, the case must match.

• By default icase=1, which means ignore case.

• If set to 0, the case must match.

Suggest you don't use a Regex here, you don't need it.  Store all of those values in a Text Input tool with fields like 'Find this text' and 'Replace with'

Then use a Find Replace tool.

Chris

[sslattery17]

@binuacs 

When I bring in all the property data; the first column [Bldg-Unit] has both the property name and the unit numbers.  I have created a formula that works to copy the property names to a new property column.  Now I am trying to remove the property names from [Bldg-Unit] leaving the unit numbers.  Sometimes those unit numbers include letters for example 200A or 200-G not always just nemeric.  I tried using the cleaning tool; I guess the replace or regex wont work....This is the same workflow I have the problem with the summarization issues.  I have tried to resign the workflow, approach it differently and cant seem to get there.  Been working on it for two weeks... 

11th & Spruce
Oct 2024
[Null]
Unit Details
Bldg-Unit
201
[Null]
202
[Null]
203
[Null]
[Null]
[Null]
[Null]
[Null]
204
[Null]
[Null]
[Null]
[Null]
[Null]
205
[Null]
206
[Null]
[Null]
[Null]
[Null]
[Null]
[Null]
207
[Null]

[sslattery17]

@ChrisTX thanks for this.  Its not working as expected because of other data I cant cleans

[binuacs]

@sslattery17 just to trying to understand the requirement here, below given your sample data, what is the expected output you are expecting based on the below data