Split strings

Help
, , , ,
1

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.

2

hi @RPA3

Can you share the excel

Thanks

ashwin S

4

Hi @RPA3

use assign activity like

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

Thanks
Ashwin S

5

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

6

Hi @RPA3

Use Write Cell and print or use output datatable activity

Thanks
Ashwin S

8

Hi @RPA3

try this

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

Thanks
Ashwin S

9

Error: array of string can not be converted to string

10

Hi @RPA3

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

Thanks
Ashwin S

11

same error:(

12

Hi @RPA3

can you change the string type to String

Thanks
Ashwin S

13

What difference string and String?:smiley: