I'm using ARIS Architect and trying to get the information of the locations of each EPC and group on to my query spreadsheet. I used "QUERY_ITEM_PATH" formula and it gives the one by one steps until the very end point as I need it. But since the path information has "\" and location value in the properties of each model has "/" in their writings, I can not use the path values for another work.

I'm wondering if there is another way I can get the location information with a formula or anything as exactly as its shown in the properties of each model.

Thanks for the help,


Tags: ARIS 10 Enterprise Architecture EPC Queries Report