I am working with a view in ArcGIS Enterprise Portal. This view contains combined information about the same asset, for example, pipelines. Some of the information has been combined into a single attribute field, separated by a pipe [ | ]. An example would be pipe diameter: "48 | 54" (for a reducer).
My question is how to split this attribute field by the pipe, for searching and filtering purposes. I am unable to perform a field calculate on a view. It doesn't necessarily need to be split into separate fields, however if that is the only way, that would be helpful to know.