Last post Oct 21, 2014 10:33 PM by Kevin Shen - MSFT
Oct 20, 2014 10:34 PM|Oday322|LINK
I am trying to read data from 1 MS access table to populate certain fields in a 2nd MS Access table, using Expression Web.
When I read table 1, store that fields in a cookie variable, and then read it into another table, I get strange characters in the 2nd table...
The original table has "Mr. Greg R. Johnson" in the name field. The 2nd table has "Mr%2E+Greg+R%2E+Johnson" in the name field....
How do I format the data so table 2 data matches table 2 data?
Let me know what else you need to know to be able to help me troubleshoot this. I am new to using Expression Web.
Oct 21, 2014 10:33 PM|Kevin Shen - MSFT|LINK
According to your post ,it seems that the "." in "Mr.Greg R.Jhonson" has been replaced with "%2E+".
I suggest that you first set a breakpoint on your code and check the value which you get from table1 ,check the value is "Mr.Greg R.Jhonson",
then check the value which you save into the table2 is the same as the "Mr.Greg R.Jhonson".check if you have changed the value in your code.
then if it still have issue ,i suggest that you can use string.Replace method to change "Mr%2E+Greg R%2E+Jhonson" to "Mr.Greg R.Jhonson"