How to check if the string has value or no

Hi

This is the mail body which I have
name : shirin
Country : India

I need to check if the column country has value or no
the value of the column country is not mandatory to have value

so I firstly need to check if it has value then fetch that value
any solution how to do it

@Apchu

You can check as below, For this you can use Regex

image

this will get your country result

Place a If condition and check if that returns a value or null value

Hope this helps you

Thanks

use if and in if use:

Var = Nothing or Var.isNothing or Var.lenght >0

@Apchu - Please refer this file for your excepted output.

Main.xaml (6.1 KB)

Happy Learning :slightly_smiling_face: