Hey,

I'm processing a csv file that contains one field that has a folder hierarchy like:

"FOLDER1\FOLDER2\FOLDER3\FOLDER4"

This a folder list that I need to import to a table like:
FOLDER_ID | PARENT_FOLDER_ID | FOLDER_NAME

So I need to parse each of the rows in the csv file into something like:

PARENT_FOLDER | FOLDER
              | FOLDER1
FOLDER1 | FOLDER2
FOLDER2 | FOLDER3
FOLDER3 | FOLDER4

... so that I can insert it in the database.

Any ideas to solve this?

Thanks a lot!
Manuel Gomes