can’t replace ? in csv file?

Posted on

QUESTION :

There are some ? in a column content, now i want to replace it with a batch. when i Ctrl+F,put the ? in the replace box.then click ok, it shows the formula is too long。 how do i do? thank you

ANSWER :

You need to escape the ? with a ~, otherwise the ? is used as a wild card. That is, put ~? in the Find What box

Leave a Reply

Your email address will not be published.