String Split option..Bind to excel

Help
, , ,
1

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.

2

@suresh_kumar4

Use filter datatable activity to delete empty rows.
image

3

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

4

This will remove the empty entries if any after split.

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

Regards,
Karthik Byggari

5

Hi @suresh_kumar4

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

cheers :smiley:

Happy learning :smiley: