create column consisting only a directory path string

[djtrabp]

Example contents of a column called Data Item 3 :-
My Folders']/folder[@name='R & D']/folder[@name='Cube']

I'm trying to create a column which has a string as follows:-
My Folder/R & D/Cube from the above column called
Data Item 3

I tried the replace function as follows :-
replace([Data Item 3], ''']/folder[@name=''','/') ,but the message was QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-228'. UDA-SQL-0219 The function "replace" is not available as an external, database, or built-in function.

How do I create a column with the string ->
My Folder/R & D/Cube

Also remember that there may be different Subdirectory levels for example -> My Folder/R & D or more levels for example My Folder/R & D/Cube/IPM

 

[almeids]

I'm assuming you are using Oracle, or some other db with a "Replace" function...
that error message indicates that you used the function somewhere that local rather than db processing was occurring, for example at the Query level. Try moving your calculation down into the tabular model or sql, there's no reason it shouldn't work. You'll need to nest multiple Replace variations to handle the boundary conditions (top and bottom levels of your path string, where you are stripping a different character sequence than in the middle of the string).
Steve