Forum Discussion

AlbertoGP84's avatar
AlbertoGP84
Regular Visitor
3 years ago
Solved

How to extract a specific value from a list nested in a table

Hi Everyone, please have a look at the below screenshot. I have a list nested in each row of my table and I need to extract only the information in the list about full filename ending either ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi AlbertoGP84 

     

    Download example XLSX file

     

    Try this in a new column

     

    try List.Select([Files], each Text.Contains( Text.Lower(_) , ".zip") or Text.Contains( Text.Lower(_) , ".pdf")){0} otherwise null

     

     

    I don't know if the filenames will always be in lower case, so I'm forcing that by using the Text.Lower function to make sure the filename will match against either .pdf or .zip

     

    I also don't know if there will always be a matching filename.  If there isn't an error will occur, so I've used try .. otherwise to trap that and output null in such cases.

     

    If you are still having issues with this, please post some sample data.

     

    Regards

     

    Phil