Trying to read an CSV file with blank fields

csv
studio

#1

Hi,
I’m trying to read an csv file with one blank field and want an error message to pop up whenever there is blank field. I’m trying this is for testing purposes. Please help.

Thanks!


#2

As long as it is a well-formed CSV, the Read CSV activity should be able to read it.
This sample has a CSV file with blank fields: CSVBlankFieldTest.zip (2.0 KB)


#3

I got the reading part. But how can I show a message box if the field is empty? Thanks!


#4

One way to do that is to use an If activity to check whether the field length is 0 and display a message if that’s the case: CSVBlankFieldTestMessage.zip (2.3 KB)


#5

@ys15,sample


#6

Thanks Sreekanth. Is it possible to have “|” pipe as a Delimiter in UiPath.