Skip to Content
0
Aug 21, 2023 at 06:18 PM

How to Trim data when we have open and close parenthesis

310 Views

Hi Team,

As per my request, the address column data in the following must be trimmed.I tried the function substr([address]);Pos(address);"1.2")-1;length([address]), but I couldn't achieve the necessary results because the decimal values are not constant.

image.png

Attachments

image.png (9.8 kB)