Dividing the data in the string variable

[ppr (Peter Preuss)]

@vinjam_likitha

items is a string variable

we can split the string e.g. when like above
arrPart = item.Split(","c).Select(Function (x) x.Trim({"'"c})).toArray

First Segment
arrSplit = arrSplits .Skip(0*50).Take(50).toArray

Second Split:
arrSplit = arrSplits .Skip(1*50).Take(50).toArray

…
With variables and some other techniques, we can fully dynamize it

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…