How to split the values in a single cell

Help Automation Ops
,
1

If 2 or 3 values are there in single cell how to split them into different cells
how to split the values into individual cells

2

Hi @anjani_priya

provide the input and required output for our better understanding.

3

Book1.xlsx (297.5 KB)
in the number column how to remove the split the more values into more cells

4

For this row there is two values, where you want to write the second value.
image

Hope you understand!! @anjani_priya

5

the next down cell
but the actual down value should not overwritten by it

6

Lets assume we split col2 and wil create seperated rows by also reusing col1 value for the second row

Assign activity
dtSplit | DataType: DataTable =dtData.Clone

Assign Activity
dtSplit=

(From d in dtData.AsEnumerable
Let arrSplit = d("Number").ToString.Trim.Split(Environment.NewLine.ToCharArray,StringSplitOptions.RemoveEmptyEntries)
From s in arrSplit
Let ra = new Object(){d(0), s.Trim()}
Select r = dtSplit.Rows.Add(ra)).CopyToDataTable
7

should i write this in invoke?

8

We mentioned assign Acitvity

9

can you send the sample code like whole code

10

just share with us screenshot / the xaml of what you had implemented so far

11

export1.xaml (9.5 KB)

12

Xaml looks fine
please update the your LINQ with above revised version

and you will get:

grafik
grafik480×756 65.4 KB

13

SplitCellValue.zip (8.6 KB)

Use This Workflow

Thanks

14

no reflection.Same as it is after I run the code

15

should I take write cell or write range for writing

16

Capture103
its not splitting

17

Hi @anjani_priya

Find the attached zip file with your expected output in the output sheet of excel

Forum.zip (743.7 KB)

Hope it helps!!

18

image
image858×739 23.9 KB

Please find the Screenshot and do Same

19

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