How to get maximum length of a string

Help Community
1

How to get maximum length of a string for a particular column in a datatable

2

Hi @Prem_Chand1 ,

currentRow(“yourcolumnName”).toString.length

Using this you can get it

or if you need maxlength of your column:

DataTableName.Columns(“ColumnName”).MaxLength

3

Hi @Prem_Chand1

You can use the following query in the Assign activity to get the desired result:

maxLength = dataTable.AsEnumerable().Max(Function(row) row.Field(Of String)("ColumnName").Length)

Here, maxLenght is a variable of type Int32.

Hope this helps,
Best Regards.

4

When: the longest string in the column
Then: as mentioned above with the usage of LINQ Max Operator

When: the data column config setting is meant
Then: YourDataTableVar.Columns(ColNameOrIndex).MaxLength

5

Thanks so much I tried many ways but it could saved my day :grinning::grinning::grinning:

1 Like
6

Can you suggest best way to learn linq @arjunshenoy

7

I tried this way it will give -1

8

It might be the case that the maxlength is not set for that column, that means it could take a string of any length.

You would have read the DataTable from some source, hence this -1 is coming.

Thanks

9

have a look here

10

@Prem_Chand1

The following resources might help you with the learning:

Best Regards.

11

grafik
grafik917Ă—615 19.3 KB

12

Hi @Prem_Chand1

Use the Len function in an If condition to compare the length of the current value with the maxLength variable. If the length is greater, update maxLength with the new value.

Assign activity: maxLength = 0

For Each Row activity (DataTable = yourDataTable)
Assign activity: currentValue = row(“ColumnName”).ToString()
Assign activity: currentLength = Len(currentValue)
If activity: currentLength > maxLength
Assign activity: maxLength = currentLength

Thanks!!