How to delete/remove from starting to a specific item of an array

Help Studio
, , ,
1

Hi Team,

I have an array[string] with values {a,b,c,d,e,f,g,h,i j}

I need to remove the items starting from d : {a,b,c,d}

Output shoule be : {f,g,h,i,j}

Appreciate your help!

2

Hi @suresh.ghadai

You can try array except function

Enumerable.Except Method (System.Linq) | Microsoft Learn

Like this ouputarray = numbers1.Except(numbers2)

image
image1402Ă—1001 58.8 KB

Thanks
John

3

image

4

@johnfelix . Thank you!

5

Hello @suresh.ghadai ,

You can use the below method.

list.GetRange(list.IndexOf("d"),list.Count-1).ToList

Thanks,
Sanjit

6

@Sanjit_Pal,

My value is in a string array i.e InputArray

The above method is not working for Array

Please get same method in Array.

7

you can convert that array to list using arrVar.ToList and use the above method and at the end you can again convert it to array using arrVar.ToArray

1 Like
8

@Sanjit_Pal

image
image1138Ă—201 11.2 KB

Please check once. I am getting an error.

Note: SrArray is my Array of strings

9

@Sanjit_Pal

Sorry SrArrayList is my Array name

10

the method name is IndexOf not index

11

@Sanjit_Pal

Hi Sanjit,

I have an excel sheet with 6 sheets. By applying the below method it is removing only one sheet. If am providing the out_Config(“WorkingSheet”).ToString =Sheet3
I should be getting the value for Sheet4, Shee5 and Sheet6
out_Config(“WorkingSheet”).ToString= Sheet4,
I should be getting the value for Sheet5 and Sheet6

Excel sheet has : Sheet1, Sheet2, Sheet3, Sheet4, Sheet5 and Sheet6

arraySheet.ToList.GetRange(arraySheet.ToList.IndexOf(out_Config(“WorkingSheet”).ToString),arraySheet.ToList.Count-1).ToArray

Please help on this!

12

have a look here
image

image
image879Ă—49 2.82 KB

workSheetsList.Skip(workSheetsList.IndexOf(“Sheet3”)).Take((workSheetsList.Count-1)-workSheetsList.IndexOf(“Sheet3”)).ToArray

13

@Sanjit_Pal

image

image

Getting the above error. Please see
the method , anything i have missed …

Your help will be appreceiated!

14

If you have Queries, Don’t close the topic and ask Question.

Before mark as solution You should check the expected output after that you should mark a solution.

If you your are discussing about the new query create a new topic @suresh.ghadai

15

kindly check are you having the values in out_Config or it’s null?

16

No Sanjit . i am getting value for Out_Config

17

@Gokul001
Sorry by mistakenly it was clicked on solution. It was same query.

Thanks!

18

No worries. Kindly click it back again and continue to discuss @suresh.ghadai

19

can you please share your xaml with sample data I will correct and share it with you.

20

Hi @suresh.ghadai ,

If you need the Sheets that are present after the Sheet that needs to be searched/indexed, then you could try the below :

wbSheets.Skip(wbSheets.IndexOf("Sheet3")+1)

image