Good Morning. I have a data file(.DAT) wherein it has “occurs” clause in it, where the data appears in the same row in sequential order, I want to split these data to a separate column. Is it possible to do this using UiPath? Thankyou.

Hello @Chendoran_M You can try with Generate Datatable or Text to Column activity. [UiPath- Text to DataTable |Generate DataTable & Text to Columns activities] Thanks

Split columns in .DAT file

Help Studio

Anil_G (Anil Gorthi) December 13, 2022, 7:00am 2

@Chendoran_M

Try using a read text file and read the data from .dat file…then use your split activity

Str.split({“occurs”},stringsplitoptions.none)

Cheers

1 Like

Topic		Replies	Views
In excel automaion how to split the columns data Help studio	2	1346	June 29, 2019
How to separate multiple merged data in 1 column into individual columns? Studio studio , question , activities_panel	5	1103	June 28, 2022
Excel - Text to Column Studio excel	5	1824	May 21, 2020
How to Split Merged columns using Uipath activties Studio datatable , excel , activities	3	947	June 15, 2020
Create datatable from space seperated excel file Help datatable , excel , uiautomation , activities , studio	2	3390	August 7, 2018

Split columns in .DAT file

Related topics