Excel delimeter

how seperate data using delimedelimenter

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.

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

@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.

Data write as on excel (system. String)

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

@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.

Hi,

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

Regards,

1 Like

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 .