Assign Proper Case Temp Variable: No data is available for encoding 1252. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method

Feedback Forum
,
1

image
image1067×789 56.7 KB

StrConv(City,VbStrConv.ProperCase)

How to solve it?

3

Hi @Dingkun_Yang

Try the below expression,

System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(City.ToLower)

Hope it helps!!

4

Hi,

Probably, it’s necessary to call the following in advance.

System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance)

The following topic will help you.

Regards,

2 Likes
5

It works.
Thank you.

1 Like
6

It’s my pleasure… @Dingkun_Yang

Make my post Mark as solution to close the loop.

Happy Automation!!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.