formatting workflow

[45134904]

1.First Name and Last Name should not have special characters (#, ?, (), &, +, /, !, @) - need logic Alteryx work flow

2.Address Line 1 should not have special characters (?, (),!) - need Alteryx workflow

[Amol_Telore]

Hey @45134904 

If I understand you correctly you are trying remove special characters from First Name & Last Name and Address Line. To do this you can use Replace_Char formula

1. ReplaceChar([FirstName], '#?()&+/!@', '')
2. ReplaceChar([LastName], '#?()&+/!@', '')
3. ReplaceChar([Address Line 1], '?()!', '')

[45134904]

no its like true and false if this special characters present then its false if not then true .

[Amol_Telore]

Hey @45134904 

Use below code to validate your data against special characters. 

1. regex_match([FirstName], '^[^#?()&+\/!@]*$')
2. regex_match([LastName], '^[^#?()&+\/!@]*$')
3. regex_match([Address Line 1], '^[^?()!]*$')

Output result of regex match is True or False. I hope your query is resolved.