List to upper and remove spaces

Help
, ,
1

How to convert the list of string to upper and trim

2

Hey @Sweety_Girl

Use a for each loop to iterate through the list of string…
Inside the loop, use an assign activity to convert the value to upper case and trim.

Item = item.ToString.ToUpper.Trim

3

You try with C# functions

myList = myList.ConvertAll(d => d.ToUpper());
1 Like
4

Hi @Sweety_Girl,

Using the Linq , you can do it in single statement.

  • Declear a list string variable to get the result like name as lstResult.
  • Using the assign activity lstResult = lstInput.Select(Function(a) a.ToUpper()).ToList()

Regards
Balamurugan.S

2 Likes
5

can we also add remove whitespace in this?

6

Just add trim like below
lstResult = lstInput.Select(Function(a) a.ToUpper().Trim()).ToList()

2 Likes
7

Hi @Sweety_Girl

Use for each item in LstResult

use item.ToString.Replace(" “,”")

Thanks
Ashwin S

8

this one

9

Any idea without looping

10

If you want to remove all the whitespace use below code
lstResult = lstInput.Select(Function(a) a.ToUpper().Replace(" ", string.Empty)).ToList()

5 Likes
11

Thank you so much

2 Likes
12

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