How to pick comma seaprated string from same cell

Help Activities
, ,
1

I have a multiple file paths in single excel cell. I want to pick one by one and add them to data table in get transaction state to process the files one by one. we are not using queue we use datatable.

2

@pravin_bindage

Create a array or list variable & call that multiple data cell for the variable then use for each activity will get one by value.

Thanks
Varun

3

HI @pravin_bindage

You can try with Split expression

Split(Yourstring,",")(0) -> It will get the first file path

Split(Yourstring,",")(1) -> It will get the second file path

You can get the count based on the expression and loop through to get all the dat by incrementing the count.

Regards
Gokul

4

C:\Users\Uipathuser\Alberta Investment Management Corporation\2020\Local Authorities Pension Plan\Claim Forms\Forms Completed Not Signed, C:\Users\Uipathuser\Alberta Investment Management Corporation\2020\Public Service Pension Plan\Claim Forms\Forms Completed Not Signed,

it gives me 3 string & last one is empty
how avoid that 3rd string

5

@Gokul001 do you know solution?

6

you can use something like this.

input.Split(","c, StringSplitOptions.RemoveEmptyEntries)

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.