Parse Error

[kimberly_meyer]

Hi,

I get the "Parse Error at char (0): Type mismatch in operator +. (Expression #1). Should I be using the Formula when I'm trying to concatenate?  Please help! Thanks!

[AkimasaKajitani · Accepted solution]

Hi @kimberly_meyer 

The error is caused by that the data type is not correct.

I think you are trying to concatenate numeric type data as a string.

Please add the ToString function.

ToString([PO Number])+ToString([PO Line Number])

[AngelosPachis]

Hi @kimberly_meyer ,

Your expression looks correct and yes you should be using the formula when you are trying to concatenate. 

Can you check that both fields are of string data type?

If they are not then maybe you can wrap each one of them with a Tostring formula, so your expression would be

Tostring([PO Number])+Tostring([PO Line Number])

Hope that helps,

Angelos

[aluthra]

Hi @kimberly_meyer,

Make sure that both columns are string data type and it should work

Thanks,

Amit

[kimberly_meyer]

Thank you all!  It works now!

[kimberly_meyer]

So, I have another parse error and I tried using the Tostring....any thoughts as to how to fix this one?

[Luke_C · Accepted solution]

Hi @kimberly_meyer 

In this case you appear to be doing a mathematical operation rather than concatenation, so you would not use the tostring function because you can't perform math on strings, only numbers. If you still have an error after removing the tostring functions, try using 'tonumber' instead. You may also want to change the data type of the new field to be numeric.

[kimberly_meyer]

Thank you!!