Not looking for someone to provide a full script (unless someone wants to be kind enough to do so) looking to figure our or get some direction (after searching on the internet and not finding answers) as to how to search an excel CSV file for special characters (or any specified characters) and removing them leaving the remaining text in the field only.
Example: Say a field has abc*123. I would like to remove the * leaving abc 123.
Not sure how this would be done if someone could share a path to finding how to do this I am willing to do the scripting and learning to make it work ... just very unfamiliar and unsure where to start
looking to do this with batch scripting as that is the scripting I am most familiar with currently
tried using this
for /f "delims==" %%A in (customer.csv) do set string=%%A & echo !string:*= ! >> output.csv
but that removed the entire field of each not leaving the rest?
Please let me know what I may be missing.