# CSV character being added when splitting string **URL:** \ **Category:** Questions\ **Created:** [June 9, 2023, 5:39pm UTC](https://community.make.com/t/csv-character-being-added-when-splitting-string/11983 "2023-06-09T17:39:10Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Devan\_Kreitzer](https://avatars.discourse-cdn.com/v4/letter/d/e68b1a/32.png) [@Devan\_Kreitzer](https://community.make.com/u/Devan_Kreitzer)\ **Post date:** [June 9, 2023, 5:39pm UTC](https://community.make.com/t/csv-character-being-added-when-splitting-string/11983/1 "2023-06-09T17:39:10Z")
Hello! I have created a scheduled automation that will query my Airtable view, create a CSV of that view, then email the results over to some stakeholders. I have two “Contact” fields (separate field names) that are linked fields. To avoid obtaining the recordId’s, I created a Lookup field that is just the names of the contact. My scenario then uses the Create CSV (advanced) module to map fields to CSV headers. What I’ve found is that when I send the created CSV to an email, I get weird characters (Â) in-between names after columns. Example: ```auto Bob Builder, Big Bird, Charlie Brown ``` Any thoughts on how to fix this? ---
**Author:** ![Runcorn](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/runcorn/32/9169_2.png) [@Runcorn](https://community.make.com/u/Runcorn)\ **Post date:** [June 10, 2023, 4:04am UTC](https://community.make.com/t/csv-character-being-added-when-splitting-string/11983/2 "2023-06-10T04:04:06Z")
HI @Devan_Kreitzer, Are you getting that `Â` character after the Create CSV module or is it only visible on email that you are sending? ---
**Author:** ![Devan\_Kreitzer](https://avatars.discourse-cdn.com/v4/letter/d/e68b1a/32.png) [@Devan\_Kreitzer](https://community.make.com/u/Devan_Kreitzer)\ **Post date:** [June 12, 2023, 5:38pm UTC](https://community.make.com/t/csv-character-being-added-when-splitting-string/11983/3 "2023-06-12T17:38:18Z")
I am creating an email attachment using the “text” from the CSV module to fill in the attachment. Within the CSV attachment (in the email), the character is showing up. I’m finding that the character is showing up when pointing towards the entire array when setting up the CSV mapping. For example, the field (within Airtable) is a Lookup field. So when trying to do the mapping within the CSV module, it comes up as an . If I click just the high-level `field[]` there is , splitting each item in the array. ---
**Author:** ![Devan\_Kreitzer](https://avatars.discourse-cdn.com/v4/letter/d/e68b1a/32.png) [@Devan\_Kreitzer](https://community.make.com/u/Devan_Kreitzer)\ **Post date:** [June 20, 2023, 5:05pm UTC](https://community.make.com/t/csv-character-being-added-when-splitting-string/11983/4 "2023-06-20T17:05:31Z")
Did you have any idea on what the issue might be? ---
**Author:** ![Devan\_Kreitzer](https://avatars.discourse-cdn.com/v4/letter/d/e68b1a/32.png) [@Devan\_Kreitzer](https://community.make.com/u/Devan_Kreitzer)\ **Post date:** [June 27, 2023, 4:08pm UTC](https://community.make.com/t/csv-character-being-added-when-splitting-string/11983/5 "2023-06-27T16:08:02Z")
I believe the issue is how the computer interprets the CSV. I’ve tried adding the exported CSV to Dropbox and when I view the file within Dropbox there is not weird character. But, if I download the CSV from Dropbox and open it, the character is there. Still unsure how to fix it. ---
**Author:** ![vendy](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vendy/32/12635_2.png) [@vendy](https://community.make.com/u/vendy)\ **Post date:** [August 22, 2023, 8:53am UTC](https://community.make.com/t/csv-character-being-added-when-splitting-string/11983/6 "2023-08-22T08:53:36Z")
Heya @Devan_Kreitzer 👋 have you found a solution to your troubles? If yes, could you share it with us please? This way our community stays neat and tidy and other users can easily find advice to similar issues. Thank you! 🌱 ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [December 7, 2023, 5:13pm UTC](https://community.make.com/t/csv-character-being-added-when-splitting-string/11983/7 "2023-12-07T17:13:34Z")