How to use split in a collection

[Axal]

Hi,

This is kinda confusing, but I'm using Split function to have a filename and filetype like this : Set(Col1, Split("test.xlsx","."))

The result as expected is a collection of those two part, but in 1 column with name "Result"

How do I get the 1st and the 2nd, lets say I want to put each in a label.

Or is there a better way to have the file name and file type ?

Thanks

[BCLS776 · Accepted solution]

You can access the two split values this way:

First(Col1).Result

Last(Col1).Result

Hope that helps,

Bryan

[Axal]

Hi,

Thank you very much.

Solved.