How to convert capitalize of first letter of word

Help Studio
, ,
1

Input:
NEW YORK
INDONESIA
CZECH REPUBLIC

Need output like:
New York
Indonesia
Czech Republic

Thanks
shaik

2
  1. Use an Assign activity to create your list:

inputStrings = New List(Of String) From {“NEW YORK”, “INDONESIA”, “CZECH REPUBLIC”}

2.For Each Activity:
Use a For Each loop to iterate over inputStrings.

Set the type argument to String.
3.Inside the loop, use an Assign activity:
item = StrConv(item, VbStrConv.ProperCase)

4.use Write Line or Log Message To check the Output

3

@shaik.muktharvalli1,

You can do it like this for a string

StrConv("NEW YORK".ToLower(), VbStrConv.ProperCase)

image
image504Ă—150 2.93 KB

4

Getting error like:

The image shows a coding interface error indicating "No data is available for encoding 1252" during an assignment operation within a workflow. (Captioned by AI)
The image shows a coding interface error indicating "No data is available for encoding 1252" during an assignment operation within a workflow. (Captioned by AI)1151Ă—406 27.1 KB

thanks
shaik

5

I am using below code not working

StrConv(CurrentRow(“Country”).ToString.ToLower(),VbStrConv.ProperCase)

6

@shaik.muktharvalli1,

What’s the error?

7

I have pasted above please check @ashokkarale

Error:

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

thanks
shaik

8

@shaik.muktharvalli1,

Can you try this one

outputString = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(CurrentRow("Country").ToString.ToLower())

The image depicts a sequence of activities in UiPath, where a data table is built, and for each row, the "Country" value is converted to title case and logged. (Captioned by AI)
The image depicts a sequence of activities in UiPath, where a data table is built, and for each row, the "Country" value is converted to title case and logged. (Captioned by AI)737Ă—705 23.8 KB

9

Thank you @ashokkarale it’s working fine now

1 Like
10

Sequence.xaml (7.7 KB)

alternate Linq Method

11

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