FlowHeater - The Data Import / Export Specialist
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values

Removing spaces in string

  • Joe
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
5 years 11 months ago #3073 by Joe
Removing spaces in string was created by Joe
I am new at this, so I'm sure this is a simple task...

I have a string that may have multiple extra spaces between words: "St Louis, MO" or "St Louis, MO" or "St Louis, MO".

In all cases I want to return only one space between each word. "St Louis, MO"

How can I do this?

Please Log in or Create an account to join the conversation.

More
5 years 11 months ago - 5 years 11 months ago #3074 by FlowHeater-Team
Replied by FlowHeater-Team on topic Removing spaces in string
Hi Joe,

To remove spaces in as string you have to use the String Replace Heater with enabled extended settings. (see screenshot below)

In the extended settings you can specify a replace list like this

5 time space,1 space
4 time space,1 space
3 time space,1 space
2 time spcae,1 space

When you disable the option “Termnate list processing after first match” the String Replace Heater loops over all entries and tries to remove first 5 spaces with one, after that 4 spaces with one till end of the list. At the end all spaces are remove and no repeated spaces should occur in the string.

In the attachment you´ll find a simple example how it works.



File Attachment:

File Name: remove-spaces.zip
File Size:2 KB

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:
Last edit: 5 years 11 months ago by FlowHeater-Team.

Please Log in or Create an account to join the conversation.

  • Joe
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
5 years 11 months ago #3076 by Joe
Replied by Joe on topic Removing spaces in string
That works great. Thank you!

Please Log in or Create an account to join the conversation.

Time to create page: 0.368 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2023 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en