String Split option..Bind to excel

Hi Guys,

After i splited the string using split function…TextLocationCodes.Split(Environment.Newline.ToCharArray)…
when i tried to bind in excel i am getting empty rows after each string…

image

I dont want that empty row after the text it should bind like cell A1,A2,A3,…

Thanks,
Suresh.

@suresh_kumar4

Use filter datatable activity to delete empty rows.
image

hi @suresh_kumar4
can you try to split like below.
it is working for me
Input.Split(cchar(vblf))

and also before write it to excel, trim the string and verify it is empty or not

This will remove the empty entries if any after split.

TextLocationCodes.Split(Environment.Newline.ToCharArray,StringSplitOptions.RemoveEmptyEntries)

Regards,
Karthik Byggari

3 Likes

Hi @suresh_kumar4

How did you bind the splited string in excel ? using?

cheers :smiley:

Happy learning :smiley:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.