Hi,
I am trying to eliminate text from a title field, some of the text can be in the front of the title and some can be in the middle or end of the title.
EXAMPLE: "US-Contingency Plan-Card-FraudDisputes-FDCM-KDC3-014", I would like to exclude "US-Contingency Plan-"
and in the same set of data there is "2ND_LEVEL_IRIS_SUPPORT-003_Restart IRIS Webservices||IRNO: more text here", I would like to exclude "||IRNO:"*
Any help would be greatly appreciated. I also assume this will grow so I will need it to be somewhat flexible.
Thanks, but I am not sure this would be the best way of doing it, I am dealing with hundreds of thousands of rows, I would need to click on each one. The title I am mentioning is a title field of data, not the title field of the report. Basically I am looking to parse out information in the data, but the information can be in different places in the data.
