topic Re: How to remove unpredictable spaces in column value? in Talend Studio

How to remove unpredictable spaces in column value?

RDhage1644252496 — Fri, 15 Nov 2024 23:14:24 GMT

I have requirement where in order to match the names from lookup table to main table, I need to remove spaces from input value.

For ex. Input -"ABC<space><space><space> DGJ"

Lookup value "ABC<space>DGJ"

Some values have 3 spaces between it or some have have 2 spaces between name. How can i eliminate these without using too many replace?

Anonymous — Mon, 07 Feb 2022 18:12:40 GMT

This should work for you.....

row1.columnName.replaceAll(" +", " ")

gjeremy1617088143 — Tue, 08 Feb 2022 07:54:37 GMT

Hi, and if you want to keep only one space:

row1.columnName.replaceAll("(?<= ) +","")