Sep-30-2016, 04:17 PM
Hello,
Ive got a script that builds a list based on data from a spreadsheet.
Each item added to the list is a string, some of which contain special characters like $, *, @, etc.
What Id like to do is remove the special characters from each item in the list.
So if the spreadsheet has 'blah $blah' Id want just 'blah blah'.
I was thinking it may be best to create a list of the characters I want to search for, then loop over each character of each list item.
If anyone could help with some pseudo code, it would be greatly appreciated.
Ive got a script that builds a list based on data from a spreadsheet.
Each item added to the list is a string, some of which contain special characters like $, *, @, etc.
What Id like to do is remove the special characters from each item in the list.
So if the spreadsheet has 'blah $blah' Id want just 'blah blah'.
I was thinking it may be best to create a list of the characters I want to search for, then loop over each character of each list item.
If anyone could help with some pseudo code, it would be greatly appreciated.