I have a table with field which contains path to database. The same thing in this field will be the extension of file. Here is how it looks like
D:\Проекты\Москва для тестов\Test.gdb\graf_fd
I need to have this
D:\Проекты\Москва для тестов\Test.gdb\
Probably I should replace everything after 'gdb\'. I know that I can type something like delete last 7 charachters, but the name of dataset can be another in other databases as well as the length of string data before 'gdb\'. So are there codes for removing or replacing the characters after certain word?