How to insert Tab delimeter in Text file

Hello Every one,
Here i want to convert Excel spread sheet to txt file with tab delimeter in each row, is there any way to do

@adarsh_kotagiri,

Try with this workflow, it may help you.

It needs an input excel from your desktop named as “Data.xlsx” with sheet1.

Tab_Delimiter.xaml (9.3 KB)

2 Likes

@adarsh_kotagiri
we can do like following:

  • read range - readin excel
  • write CSV - configured wit delimiter to tab

https://docs.uipath.com/activities/docs/write-csv-file

2 Likes

sir what if i want to change in to other delimeter like pipe ,space ,comma

@adarsh_kotagiri ,

You have to change this vbTab in two places with your required delimeters

1 Like

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