I am trying to run a model on a dataset, and in doing so I create new features from the input spreadsheet. The NAME_SHIP field is being used to create the names of the new feature classes but the field is set up with illegal characters. I am already using one CALCULATE VALUE tool in my model but found that some of the ship names also include an " ' " (apostrophe) in them. Is there a way to either:
- Include an expression in the already existing CALCULATE VALUE to rid the names of the apostrophe? or
- Where do I insert another CALCULATE VALUE tool in the model to fix for both issues while creating a new FC?