Special characters restriction

[listoftenstuff100]

Hello Alteryx Community!

Can you please explain how to allow periods only for a cell that contains ".com"? I am assuming this is accomplished with a condition in Formula but am new to Alteryx.

I would appreciate your help very much!

[Qiu]

@listoftenstuff100 
Since I am not sure what kind of output you will need, so tried a filter and a Formula tool

[listoftenstuff100]

Qiu, thank you so much for your quick response.

How would you make it so that the "BB.net" appears as "BBnet"? But AA.com remains "AA.com"?

[Qiu · Accepted solution]

@listoftenstuff100 
This is just an example, since it will replace any '.' that not coming with 'com'.

In your really data, it may cause unintentional results.

[Qiu]

@listoftenstuff100 

Thank you for the accept mark. 😁

[listoftenstuff100]

Your welcome. Thank you for helping!