Delete undesired part of text from dt

Hello,

I am scraping data dable from MS Office application and pasting it back to excel.

The issue is that some undesired text, not visible in MS Office table is added.

e.g.
insead “235” in written in excel I get “235 Button”.

This happens in many various columns of the DT.

What is the best way to delete this undesired part of the text?

Thanks!

did we tried using split method??

1 Like

Hi @sspi1153

You can use split method as suggested by @Pradeep_Shiv
else u can also go with substring if you know the length of the string.

Hope it helps!!

1 Like

Thanks!

1 Like

did it work?
@sspi1153

Thanks for the help, but the issue is that I don´t know how to integrate the soluiton in data table.
This work if I have on cell. Is the best solution for the DT to use for each cell activity?
In this case the process can take to much time.

Thanks!