How to convert list of text string to list

You won't be able to "delete" anything.  You can clean up your results in various ways, but it depends on what you want.  Do you just want all non-null values?  Do you want to exclude just rows that contain all nulls (but not exclude ones that contain any data even if mixed with SOME nulls)?  It's pretty unclear here what you're starting with and what you're after, so it's hard to make any definitive recommendations.

 Mike Schmitt 

I want to read an excel file and check the contents of the excel file. I want to retrieve only rows that have values.
I was able to load excel file and  i'm trying to check the contents of the excel file using a loop, but I can't..

How can i clean up my excel file result 

Could you share your existing code? Below is a simple example. Can give a cleaner code if your code is available here.

a!localVariables(
  local!doc: ri!doc,
  local!data: readexcelsheetpaging(
    excelDocument: ri!doc,
    sheetNumber: 0,
    pagingInfo: a!pagingInfo(startIndex: 2, batchSize: 5000)
  ).data.values,
  local!formatData: a!forEach(
    items: local!data,
    expression: {
      if(
        a!isNullOrEmpty(fv!item[2]),
        {},
        a!map(
          id: fv!item[1],
          name: fv!item[2],
          gender: fv!item[3],
          department: fv!item[4],
          tech: fv!item[5]
        )
      )
    }
  ),
  local!formatData
)

Could you share your existing code? Below is a simple example. Can give a cleaner code if your code is available here.

a!localVariables(
  local!doc: ri!doc,
  local!data: readexcelsheetpaging(
    excelDocument: ri!doc,
    sheetNumber: 0,
    pagingInfo: a!pagingInfo(startIndex: 2, batchSize: 5000)
  ).data.values,
  local!formatData: a!forEach(
    items: local!data,
    expression: {
      if(
        a!isNullOrEmpty(fv!item[2]),
        {},
        a!map(
          id: fv!item[1],
          name: fv!item[2],
          gender: fv!item[3],
          department: fv!item[4],
          tech: fv!item[5]
        )
      )
    }
  ),
  local!formatData
)

Konduru Chaitanya 

Thank you so much for your help. It work for me