Removing specific character from DT column list

[Cormac (Cormac White)]

Hello

How would you write the expression for removing a character from a list under a column for e.g.

Column1
123,4
123,5
123,6

and removing the ,

Can I use the assign activity here?

[Palaniyappan (Palaniyappan P)]

Hi
The expression be like this
dt = dt.AsEnumerable().Orderby(Function(a) a.Field(of string)(“Column1”).ToString.Replace(“,”,””) ).CopyToDatatable()

Cheers @Cormac

[gulshiyaa]

Hi @Cormac

You can use for each row then assign var =row(“column name”).testing
Then use other assign activity then create new var = var.replace(“,”,“”)

If you find it useful mark it as solution and close the thread

Cool,
Regards,
Gulshiyaa

[Cormac (Cormac White)]

Hi Palan

I am getting the following error

[Cormac (Cormac White)]

Also - doing this as well from the last time you help me. Would the error be because I am using the same DT?

[Palaniyappan (Palaniyappan P)]

Is this assigned to any Boolean variable or argument
Or
May I know where it is used
It would be in ASSIGN activity
Cheers @Cormac

[bcorrea (Bruno Correa)]

dont copy and past from here, remove the quotes and type them again

[Cormac (Cormac White)]

It is just used as a variable within one sequence. I am using it as an ASSIGN in the first and second screen shot. Would the problem be that I am using ASSIGN twice?

[Cormac (Cormac White)]

[Palaniyappan (Palaniyappan P)]

Get the cursor to that blue mark in that activity so that we can know what is the error
Cheers @Cormac

[Cormac (Cormac White)]

This is the error - TrackerDT is a variable with a variable type of DataTable

[Palaniyappan (Palaniyappan P)]

Hmm
If possible kindly share your xaml pls
Cheers @Cormac

[Cormac (Cormac White)]

Main.xaml (6.8 KB)

[Cormac (Cormac White)]

Thats the individual sequence

[ppr (Peter Preuss)]

@Cormac
You got this error as the where statement is expecting a true/false from lambda function. However @bcorrea gave you already an answer or will help you

[Palaniyappan (Palaniyappan P)]

yah
i made changes in the expression with first comment, where method can be used only when we set a condition or an assignment
so the expression be like this
dt = dt.AsEnumerable().OrderBy(Function(a) a.Field(of string)(“Column1”).ToString.Replace(“,”,””) ).CopyToDatatable()

Cheers @Cormac

[Cormac (Cormac White)]

@Palaniyappan

AsEnumerable().Groupby(Function(a) a.Field(of string)(“Column1”).ToString.Replace(“,”,””) ).CopyToDatatable()

Thanks for you help!

I think there is a problem with the .CopyToDatatable however.

I am getting the following error when I type it into assign

‘CopytoDataTable’ is not a member of 'Systems.Collections.Generic.IEnumerable(Of System.Linq.IGrouping(Of String, System.Data.DataRow))

[Cormac (Cormac White)]