could not be fully converted from wstring to a string
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am receiving the message above when I try to write my output to a .csv file. I have some fields that are longer that are not giving me an error when they are loaded into the file so I am not sure what the issue is here.
Here is what I have tried -
I used a select statement and tried to increase the length of the fields.
I used autofield to set the length of the fields
I cleansed the field and removed extra white space, carriage returns, etc. to no avail.
Anyone else run into this issue?
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I sometimes get this error when one of my records has an em dash or en dash, rather than a hyphen. You might try searching your text to ensure you don't include any special characters like this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You - I did find special characters at the end of the comment, but, now I need to figure out how to remove them. I will query the community and post the solution if I find it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you getting a warning or an actual error? In the case of special characters like em and en dashes, Alteryx will throw a warning but will automatically convert to a hyphen for you. For anything Alteryx doesn't catch, you can always use REPLACECHAR in a formula before exporting to the .csv file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I attached a screen shot to the original post, but, I can't tell what the funky characters are in order to remove them.
I tried the data cleansing tool to remove spaces (that is why there are no spaces in the text above). Tried to remove punctuation, but that did not work. I am not sure how to get rid of the warning. I will see if I can work with the regex or formula tool tomorrow to see if I can clean the comments up.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spot on, thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Another option for resolving this issue is check the Code Page on the configuration section of the Output Data tool. In my case, the default Code Page was set to ISO 8859-1 Latin I. When I changed it to Unicode UTF-8, the errors were resolved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks!
ps. the first highlighted image is highlighting the wrong row 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Resolved it for me as well. Thank you.
