How to check if there is space in given number in excel cell

Hi,
I am trying to set a condition that if cell value has space in between of the given number then throw exception. For example if cell value is 500 000, then throw exception. How to write code for it?

1 Like

hi @MJKHAN

check the condition @s row(“Column N@me”).ToString.trim

Th@nks
@shwin.S

@MJKHAN Welcome to uipath community
Try below condition and let me know

  If(UrVariableName.Contains(" "))
  {

  || True

  }
1 Like

Use if condition
And write condition as

myString.Any(Char.IsWhiteSpace)

I used this and working fine

1 Like

Use if um tour string:

YourStrin.contains(" ")
Then
Exception