Remove [ ] from string and make it an integer

[calloni]

Hello

I have a column in my data source that contains values like the following

1234

[2345]

What I need to accomplish is to remove the [] the numbers that have them.

What would be the best and more efficient approach to get there? Regex expression? Split?

Note: I made a couple of calculations in Tableau but they don't work the same in Alteryx.

Thanks
Rodrigo

[fmvizcaino · Accepted solution]

Hi @calloni ,

The quickest and easiest way to remove those brackets is by using data cleansing tool and config as image below.

Let me know if that works for you.

Best,

Fernando Vizcaino

[echuong1]

I would use a formula tool to clean and transform the strings since you want the values to be integers. You can use the regex_replace function to remove the brackets and then tonumber to transform the values into numbers. You can then set the datatype to Int. See attached for  an example. Let me know if that works! 

[calloni]

obrigado Fernando