Remove specific character from datatable column

studio

#1

Hi all,

I have a datatable with the “Price” column. Unfortunately, the values within column has $ sign so it was unable to sort properly. Example as shown below.

image

Does anyone have any idea how to remove a character from the entire column?

Thanks!


#2

Have a foreach loop and

row("Price") = row("Price").Replace("$","")

image

Thanks,
Prankur


#3

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