Excel Text to Column function through UiPath

Help Studio
#1

Hi all, have a datatable that needs to go through text to columns before becoming usable but is there a way to do it through UiPath Studio? I’ve googled and they say there’s an activity for it but my personal UiPath studio does not have it, not even when i search for packages to download.

Can anyone help?

image
image290×723 3.52 KB

Needs a line break (Ctr + J) to properly break into columns

#2

Hello @2101065g

Welcome to UiPath community…!

Please watch the below video.

Thanks

#3

it says to use Text to Columns activity which I do not have.

image
image386×582 2.75 KB

#4

I have tried searching for it under Manage Packages but still have nothing

image
image1120×637 16 KB

#5

can you click on the filter button and enable all categories? Also are you using studiox or studio?

Thanks

#6

Yep have tried checking under all packages, still nothing

image
image1122×632 15.8 KB

Per my class’s requirement, I am using Studio and not StudioX

#7

Try to create a new project and check it once. Hope you have created a Windows Compatibility project.

Also share the studio version.

Thanks

#8

made a new project, still the same result. can’t find the activity anywhere
image

#9

it doesn’t seem to be a community edition. Hope you are trying to use the community ediiton. If yes, please check the below video and download the community edition.

Thanks

#10

The academic version I’ve installed is per the reuirements of my course and so I am unable to use the community version