How to replace multiple Spaces with the single space by using graphical mapping

[former_member391594]

Hi Experts,

Could you please give the suggestions on below requirement.

From the sender system we are getting the data with multiple spaces in between (Ex: SAP      PI    Mapping) . And we have to replace that multiple spaces with one space.(Ex: SAP PI Mapping). Even we don't know how many spaces are coming from sender side. Scenario is JDBC to sFTP.

Thank you in Advance.

Regards,

Anusha.

[justin_santhanam · Accepted solution]

Hi Anusha,

There are so many different ways, this is just one way ( otherways are using regex etc..)

Code:

return datainput.trim().replaceAll(" +", " ");

Let us know if it doesn't help!

[former_member391594 · Accepted solution]

Thank u Justin. It is working 🙂

[Former Member]

Hi Anusha

Use this logic.

while(input.contains("  ")){

  input = input.replaceAll("  ", " ");

  }

input -------> you input field.

input.contains("  ") -----> Use 2 spaces between double quotes.

input.replaceAll("  "," ") ---------> replace 2 spaces with 1 space. First double quotes will have 2 spaces, and second double quotes will have 1 space.

Regards

Osman

[former_member391594]

Thank u Osman. 🙂