I’m hopeful

Remove Newline Characters From Gamertags in User Reports

I've been having some trouble working with the data in a user report that I downloaded. I'm using the LOOKUP() function in Numbers (I imported from the CSV I downloaded in GameLab), and none of my formulas were working. I realized that it's because I was trying to search for the value in the Gamertag field and relate it to another table that had the same value. The problem: Gamertags in the User Report have newline characters before and after them, so a field that just contains the Gamertag does not have the same value as the Gamertag field in the User Report. Would it be possible to remove these newline characters so that the CSV that Gamelab exports only has the Gamertag in the Gamertag field?
1 person likes
this idea