Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

replace parentheses with -

ilotvin
7 - Meteor

Hi all,

 

What is the best practice to remove the parentheses of a number and add the -

(40,000) to be -40,000

I feel like the answer relates to the regex replace but I'm new to this tool and appreciate your help.

 

Thank you in advance

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
How about replacing ( with - and ) with nothing?

Replace(Replace[field],"(",'-'),")",'')

All in one expression because I'm typing on my phone.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
ilotvin
7 - Meteor

Thanks! Perfect solution!

Labels
Top Solution Authors