How to replace special caracters like " ' & ....
-
I have an xls file to create but it's name is automatically generated, so it may include some special caracters like ' " , or even é à ... so i must replace these caracters by a simple underscore before giving the name of the file. so how to do that ? how to fix the list of these caracters ? could i use their ASCII codes just to not have to enmumerates all of them ! thanks in advance
-
I have an xls file to create but it's name is automatically generated, so it may include some special caracters like ' " , or even é à ... so i must replace these caracters by a simple underscore before giving the name of the file. so how to do that ? how to fix the list of these caracters ? could i use their ASCII codes just to not have to enmumerates all of them ! thanks in advance
Aymen, im not sure what exactly you are trying to do, as your explanation is not very clear. However, it may be possible to do what your after by either: 1) replacing letters / characters with their ASCII equivalent or 2) Use regular expressions, Splitter and Replace to find the offending characters, then replace them with something else. This combination is very effective in replacing characters in a string, and can be done in about 3 lines of code. Search for all 3 on google, and you'll get lots of examples. If however ive totally misunderstood you, then post again with a clearer explanation. Munklefish
-
I have an xls file to create but it's name is automatically generated, so it may include some special caracters like ' " , or even é à ... so i must replace these caracters by a simple underscore before giving the name of the file. so how to do that ? how to fix the list of these caracters ? could i use their ASCII codes just to not have to enmumerates all of them ! thanks in advance