Copy every line from text file and writing whole line in the Cell of excel file

Deepak_M · September 12, 2019, 3:14pm

I have a use case in which I have to copy every line from text file and write it in a Cell of Excel file.
I have attached sample text file

AshwinS2 · September 12, 2019, 3:47pm

Use read text file activity and use string var=StrText.split(“”,String split options.none)

Thanks
Ashwin.S

Deepak_M · September 13, 2019, 12:57pm

Hi @AshwinS2
Do you have any sample workflow.
I am getting error in above command.

AshwinS2 · September 13, 2019, 1:24pm

Use Read Text File

Create a string array variable

String arr1=StrInput.Split(CChar(VbCrlf))

arr1(0).ToString.trim

Thanks
Ashwin S