AnsweredAssumed Answered

strange character on FM export

Question asked by jdevans on Dec 2, 2015
Latest reply on Dec 2, 2015 by jdevans

I exported the records from a filemaker file originally created in FM5, but it is now readable by FM14. When I opened the csv file to do some edits, there are in several fields a strange character that I can't identify using the character map. I'm on a Windows 7 machine. See image for the character to the left of 626347...

 

strange_char.PNG

 

I want to do a replace using ctrl+F in Excel, but even when I select the character, do a ctrl+C and then try to do a ctrl+V into the "Find What" field in Excel, nothing pastes. It's like it isn't there.


I tried using MS Character Map, and searching. However, ctrl+V into the "Search for" field does allow the paste of the special character, but its as if Character Map doesn't see it, because the "Search" button stays greyed out.

 

I need to clean up this data before I import it into an new solution, getting rid of this special character, but as of now, all I can do is visually find them all and backspace them out manually.

 

There's got to be a better way. Can anyone tell me what this is?

Outcomes