On 06/07/2024 14:48, Roger L Costello costello@xxxxxxxxx wrote:
> Hi Folks,
>
> I want to convert this:
>
> <Airport_Name>LOWELL FLD                    </Airport_Name>
>
> to this:
>
> <name>LOWELL FLD</name>


Use `replace` e.g.

 B  Airport_Name => replace('\s*$', '')