Split strings

Hello!

I take the values ​​from the file, in each file there may be a different amount: 0,1,2,3,4, …
Then I go into the application and share them.
The data that I take from the files (and there are a lot of them) is written to DT. One file - one line. The numbers of orders (which may be 0,1,2,3, …) are recorded in one cell. First, I look at all the files, and then I go into the application.
If there are several orders in one file, then how can I write them down so that later I can identify and select each of them? Because if there are more than one order, then additional actions appear.

hi @RPA3

Can you share the excel

Thanks

ashwin S

Hi @RPA3

use assign activity like

row(“Order”).ToString=row(“order”).ToString.split("".ToCharArray)

Thanks
Ashwin S

And what then? How to use all order in with cell ?

Hi @RPA3

Use Write Cell and print or use output datatable activity

Thanks
Ashwin S

Hi @RPA3

try this

StrOrder=row(“Order”).ToString.split("".ToCharArray)

Thanks
Ashwin S

Error: array of string can not be converted to string

Hi @RPA3

use row(“order”).ToString.Split("".ToCharArray).ToArray

Thanks
Ashwin S

same error:(

Hi @RPA3

can you change the string type to String

Thanks
Ashwin S

What difference string and String?:smiley: