Excel delimeter

Help Activities
1

16161251317522815070223738774460
161612513175228150702237387744603000×3000 2.43 MB
how seperate data using delimedelimenter

2

Hi @vishal22landge , Welcome to UiPath Community!

You can use split method.

For example, Sentence = 1000551;INF209

SplittedText(Array of string Varibale)=Sentence.Split(CChar(“;”))

It will store 1000551 and INF209 in SplittedText variable.

3

But i use whole excel and read rang output data table then who to use split

4

@vishal22landge You can use For Each Row activity. By using this you can work on one row at a time. While using for each row, assign the row value to sentence variable and then split it. This will repeat for every other row.

5

Data write as on excel (system. String)

6

Hi,

What is your src file? If it’s text file, can you try to use Read Text File, (string manipulation, if necessary) , Generate DataTable to get data as datatable. Then you can write it to xlsx easily.

Regards,

1 Like
7

@vishal22landge Its writing the string of array. The items are inside it splitted by “;”. Try using one for each activity for splittedText. Inside for each activity , use write line → item.toString. This will let you check if the items are splitted or not.

8

16161300228181145910353557018214
161613002281811459103535570182143000×3000 1.88 MB

9

Hi,

Can you share your text file? It’s no problem if dummy data.

Regards,

1 Like
10

Hi @vishal22landge , Welcome to UiPath Community!

My Simple suggestion is that Please try to convert that file into excel directly using UiPath Activity .

You can use Move File Activty
From :- FileName.Txt
Destination :- FileName.xlsx

This Will Convert your text file into excel .then you can use it further in the form of datatable .Hope this fulfill your requirement .