Check if the column has empty or miscellaneous data

Hello All,

My csv file has a column “Employee code” which has empty and miscellaneous data along with the employee code (Numeric value).
Please suggest how can I find that out as my data would be large enough

what is your requirement? to filter out empty rows?

Hi @Smreti_Gupta ,

Welcome to UiPath Forum Community

Can be more specific of your requirement?

Thanks,
Ashwin

Hi,

We would need a few more details about what to extract but you can use some regular expression to be able to locate that number in that jumble of data.

Regards

1 Like

I need to upload csv file in one portal. If the column (Employee code) has empty or miscellaneous data then then portal will throw error while uploading the file.
So, to successfully upload the file, I need to check if the column has any empty or miscellaneous data in it.
I have attached sample screenshot of the file.

screenshot|690x283

Hi,

Employee code must always be a number? If so, you can use the isNumeric function that will return false when the string entered is not a number or is blank or empty.

Regards