How to copy an excel column into new sheet by spliting it

Help
1

Hi,

I have to copy the data of one column and put it into another sheet by splitting it. Contents should be in different cells in the same row and has to be delimited by “"
I created a new data table with two columns.
For each row in original DT, I fetched the row item for that column.
Then used Add data row in new_DT and I was giving below value in ArrayRow
{split(val,"”)(0),split(val,““)(1)}
Why is this wrong? Its fetching split(val,””)(0) correctly but split(val,“_”)(1) going out of range.

image
image740×357 17.7 KB

2

Hi @abhyudai_munna
Can you have a look?

3

@Swap1 Can you attach your workflow and excel file

4

delemiter.xaml (10.8 KB)
formula.xlsx (9.6 KB)

5

@indra attached!

6

@Swap1 When you are spiting text in the row 5th that is su you was getting empty value so you was getting error check updated file with solution

delemiter.xaml (15.2 KB)

1 Like
7

Yes. Missed it…
Nice catch. Thankyou so much!!

1 Like
8

Hi @Swap1,

Please take a look the below activity . It has an activity called “Copy Data”. It copies the data to clipboard. May be it useful to you.

Regards
Balamurugan.S

9