We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Add space before bracket

HW1
9 - Comet
‎02-24-2021 04:10 PM

I have a column with names as  'BP Connect Ascot(WA)' and correctly as ''BP Bathurst (Stewart St)' 

I want them to be consistent with a space before the bracket like 'BP Connect Ascot (WA)' and ''BP Bathurst (Stewart St)' 

How can I do that?

Thanks

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris
‎02-24-2021 04:15 PM

@HW1 

Like this?

CaptureV1.PNG

New Workflow5-1.yxmd
Reply
0 Likes
HW1
9 - Comet
‎02-24-2021 04:22 PM

That is not the solution I am looking for as I have 'BP Bathurst (Stewart St)' coming in correctly which will turn out to 'BP Bathurst  (Stewart St)' Which is not what I want.

Reply
0 Likes
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎02-24-2021 04:33 PM

Regex_Replace([field],"(.*\S)(\(.*)",'$1 $2')

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Reply
0 Likes
HW1
9 - Comet
‎02-24-2021 04:48 PM

It is doing nothing

Reply
0 Likes
Qiu
21 - Polaris
21 - Polaris
‎02-24-2021 04:55 PM

@HW1 
Sorry. I misunderstood. This should work.

CaptureV4.PNG

New Workflow5-2.yxmd
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All