Using IsError to trap an error when using 'Search'

[Jeff2Jets]

I am trying to parse a Windows file path to create a column for every folder in the path. However, if an error occurs (no more backslashes exist) when using 'Search' to find the next backslash, I want to be able to set the column to '-None-'. If there is not an error, I still want the folder value.

Here are two sample values I want to parse:

1. c:\folder1\folder2

2. c:\folder1

Here is my code:

Windows Folder2 =

Var Position1 = Search ("/", table[column], 1)

Var Position2 = IfError (Search ("/", table[column], Position1 + 1), 0)

Var Folder2 = If (Position2 = 0, "-None-", Mid (table[column], Position2 + 1, Position2 - Position1))

Return Folder2

For the 1st value, no error is thrown.
For the 2nd value, an error is thrown, so I want to set the Position2 variable to 0 (zero), so I can check it.

Any help would be greatly appreciated.

[amitchandak]

@Jeff2Jets ,Based on what I got

can you try split by delimiter with last occurrence option in power bi 

Power Query Split Column , Split Column By Delimiter:https://youtu.be/FyO9Vmhcfag

[Jeff2Jets]

Thank you for the suggestion, but what I really need to know is how to handle the error trapping with the 'Search' statement. Would you be able to provide an example of how to trap the error for the statement below:

Var Position2 = IfError (Search ("/", table[column], Position1 + 1), 0)

What I want is to have the 'Position2' variable be set to the location if a 2nd \ (backslash) exists, but be set to 0 (zero) if a 2nd \ (backslash) does not exist.

Thank you.