String Manipulation-Split

Learning Hub
1

Hello,
I am new to uipath.
I want to read data from text file and writing into excel.
I want to fetch every 7 string and write as 1 row in excel.and it iterating through the all the data from text file and write in text file.
Text.txt (188 Bytes) Data.xlsx (9.5 KB)

2

The Actual Text in 3 lines are default ?

3

200 lines of data in the text file.

4

Text.txt (188 Bytes) Text to Excel.xaml (10.8 KB)

Try this

3 Likes
5

Add data row is showing error.

6

Can you share Screenshot

7

Image
Image1109×439 16.1 KB

8

Can you check Once by printing the Data in Write line for Each Add data row.

9

Yes it’s printing values but writing date only. after getting error index was outside of the array.

10

Can you Try with one if Condition before Add data row .
if(count+7 <arr.length)

11

It’s not printing any data in write line

12

Hi ,

The Array had some Empty Entries.

Text to Excel.xaml (11.1 KB) Text.txt (188 Bytes)

2 Likes
13

Thank You It’s working.

14

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