How to read a null values from excel

[sweety]

I have stored my Excel file in orchestrator. from there i am reading values from excel. now i want to read the null values and throw exception.

I am using this
NOT string.IsNullOrEmpty(in_TransactionItem.SpecificContent(“Name”).ToString)
but its not throwing exception for null values.

[Anthony_Humphries]

That line alone will not throw an exception. If you want to throw an exception, you can put that condition in an If activity, and in the Else section, add a Throw activity.

[sweety]

i have used if condition. below is the screenshot for your reference.

[Anthony_Humphries]

If there are any spaces in the “FirstName” field, that will not be null or empty. Step into the code and see if there is something like that in the content.

[sweety]

No space in FirstName.

[Anthony_Humphries]

Can you show me where the process goes when you use Step Into for that value? Curious to see what path it takes when the value is blank or null.

Also, if you can provide a screenshot of what that specific content is set to from the Locals panel, that will help.

[sweety]

It will read that empty value and it will fill in application.
.
When First Name is empty it should throw exception but its not throwing

[Anthony_Humphries]

I mean in Studio, not the application itself.

[sweety]

[jcastro]

Hi @sweety,

Can you try using Trim and see if it will still proceed? It should look like this:

NOT string.IsNullOrEmpty(Trim(in_TransactionItem.SpecificContent(“FirstName”)……)

[sweety]

Thanks alot. its working:-)