could not be fully converted from wstring to a string

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?

String Coversion Error.PNG

Output

Accepted answers

Jim7

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.

All comments

Jim7

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.

Petersenk

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.

Jim7

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.

Petersenk

I attached a screen shot to the original post, but, I can't tell what the funky characters are in order to remove them.

String Coversion Error.PNG

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.

Stuart_Nulty

Spot on, thank you

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235