Exclude spaces and parentesis on typeinto

Help StudioX
,
1

Hello! I need to register numbers on a platform, but I’m using the “type into” activity and this platform does not accept spaces (’ '), parentesis (), or hyphen on the numbers. The excel sheet that I’m using has this caracters on almost every row. I’ve already tried this expression(System.Text.RegularExpressions.Regex.Replace(CurrentRow(“Telefone”),“\D”,“”).ToString) on the ‘type into’ activity, but an error keeps happening. This is how my automation looks like rn:

image
image1366×768 89 KB
can you please help? Obs: I’m using the ‘excel for each row’ activity. Best regards!

2

this is the error message: 23.6.1-beta.13324+Branch.release-v23.6.1.Sha.52787b786620e97cba5555379da6e6bb423b3e6b

Origem: Assign

Mensagem: Value cannot be null. (Parameter ‘input’)

Tipo de Exceção: System.ArgumentNullException

image
image1366×768 97.9 KB

3

take another assign replace in it
then use that variable in type into

Regards
Usha

4

@Massuh_Imoveis

System.Text.RegularExpressions.Regex.Replace(CurrentRow(“Telefone”).ToString, “[^0-9]”, “”)

I hope this will help you

5

@Massuh_Imoveis Use this Regex expression System.Text.RegularExpressions.Regex.Match(CurrentRow(“Telefone”).ToString,“[0-9]+”).ToString

6

@Massuh_Imoveis

Try this

System.Text.RegularExpressions.Regex.Replace(CurrentRow("Telefone").ToString,"\D","")

If that does not work may be the CurrentRow(“Telefone”) is blank or empty or contains only special characters

cheers

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.