Lower case output in c#

[balaraj.pubalan]

Hi Team,

how to convert the output data table text string to .lower case letter after read the row data in excel?

i tried .ToLower() but have error “InvalidLValueExpression”

[rlgandu (Rajyalakshmi Gandu)]

@balaraj.pubalan

how to convert the output data table text string to .lower case letter after read the row data in excel?

i tried .ToLower() but have error “InvalidLValueExpression”

@balaraj.pubalan

1. Add a “For Each Row” activity and set the “TypeArgument” property to System.Data.DataRow to loop through each row.
2. Inside the “For Each Row” activity, add an “Assign” activity to convert the “DateColumn” value to lowercase:

Assign activity:
row(“DateColumn”) = row(“DateColumn”).ToString().ToLower()

[lrtetala (Lakshman Reddy)]

Hi @balaraj.pubalan

Try this

LCase(kwKeyword)

[Yoichi]

Hi,

Can you try to set just kwKeyword in the Text property?

Then use the assign activity as the following.

Regards,

[balaraj.pubalan]

Have error Lcase does not exist

[B_H_Akshatha_Pai]

hope it works

Regards,

[balaraj.pubalan]

Thanks man…this works…i just curious can assign back the same variable or not :slight_smile,so it possible also…Thanks for the knowledge share

[balaraj.pubalan]

Thanks…yes…it works after assign it back.