+ Reply to Thread
Results 1 to 2 of 2

Tilde not being read correctly

  1. #1
    Registered User
    Join Date
    04-16-2024
    Location
    Roswell, GA
    MS-Off Ver
    version 2403
    Posts
    1

    Tilde not being read correctly

    I have written a program that takes a CSV file, grabs the data and creates a new CSV file in a different format. In testing I find that one of the names has a tilde over one of the characters. Example:

    Jo緌

    After the conversion When I open the new CSV file in Notepad I get what I expect:


    Jo緌

    However, when I open the file in Excel I get:

    Jo瓊o

    How do I fix this?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Tilde not being read correctly

    Can you provide a copy of the new csv file? If it has private data, you can remove it. We just need to see the "João" part.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dates not being read correctly
    By Chameleon5669 in forum Outlook Programming / VBA / Macros
    Replies: 13
    Last Post: 08-17-2023, 03:55 PM
  2. Dates not being read correctly
    By Chameleon5669 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 08-09-2023, 06:43 PM
  3. Unable to read a number. All text is reading correctly
    By JChandler8314 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-29-2020, 07:10 AM
  4. [SOLVED] Splitting text with Tilde between them
    By Jill Pleau in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-20-2020, 08:22 AM
  5. Import CSV seperated by |~ tilde.
    By Kroon__ in forum Excel General
    Replies: 4
    Last Post: 12-08-2016, 11:27 AM
  6. Replies: 11
    Last Post: 07-05-2015, 12:46 PM
  7. Read clipboard doesn't work correctly
    By marmotinchen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2011, 08:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1