M language help: get an element from a list by index

[laciodrom_80]

I'm trying to get a specific element by index from a list obtained splitting a text by delimiter, but I don't find the right function for this goal. Using List.First or List.Last I can get first and last elements, but what function should I use to get an element by index?

MyText = "5;6;9"

MyList = Text.Split(MyText, ";")

Thnaks a lot

[Zubair_Muhammad · Accepted solution]

@laciodrom_80

You can specify the item position in curleybrackets

MyText = "5;6;9",

MyList = Text.Split(MyText, ";"),
Myitem=MyList{2}

[gooranga1]

I found I would have to use ;

MyText = "5;6;9",

MyList = Text.Split(MyText, ";"),
Myitem=MyList{1}

as the indexing seems to start at 0 for me not 1.

[LivioLanzo]

@laciodrom_80

I guess this sis what you are after:

https://docs.microsoft.com/en-us/powerquery-m/list-range