Text to column delimit in Excel

[Praveen_Vs (praveen)]

In this excel i want to delimit, How can i achieve this in uipath?
Here in this attached excel i want to Delimit by checking in,
1.Tab
2.Comma
3.Other "

Input.xlsx (10.3 KB)

[ushu (Usha kiranmai)]

Hello @Praveen_Vs Please refer attached workflow

Example.zip (11.1 KB)

Input

Output

Before you run this process male sure you enable Trust access to VBA project model in an empty excel. Follow steps in the below doc

Enable trust access to the VBA project object model

[Praveen_Vs (praveen)]

I tried with some additional data, For me the output is coming like this

Input.xlsx (10.6 KB)

[ushu (Usha kiranmai)]

@Praveen_Vs For me its working fine

did you change anything in the code

[ushu (Usha kiranmai)]

@Praveen_Vs Run the attached process first to make sure it is working fine in your system. Then test with your original code

Example.zip (11.1 KB)