Solved

exist a delphi function that could remove more than one space from words?

Posted on 2010-09-17
12
564 Views
Last Modified: 2012-05-10
Hello guys,

I have a table with 10.000 lines with sentences, just like this:

"My father is working at home"

Sometimes, there are sentences with double or more space among words, exemplo:

"She  is here  with Vanessa."

I need a function that could fix it, removing more than one space among words.

thanks
alexandre
0
Comment
Question by:hidrau
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 19

Expert Comment

by:Thommy
ID: 33701116
There is no Delpi standard function, which will do that.

But I have written a function on my own. Try, if it works for your matters:

function RemoveMoreThanOneSpacesBetweenWords(s:string):string;
var
  p:integer;
begin
  s:=trim(s);
  Repeat
    p:=pos('  ',s);
    if p>0 then delete(s,p+1,1);
  Until p=0;

  result:=s;
end;
0
 
LVL 19

Expert Comment

by:Thommy
ID: 33701296
You can check functionality with the attached program...
RemoveMoreThanOneSpacesAroundWor.exe
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 33701315
just use stringreplace

Text := StringReplace(Text, #32#32, #32, [rfReplaceAll]);

Only double spaces will be changed into single spaces
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 33701324
you could run it multiple times if you have more than 2 spaces
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 33701343
thommy, don't post .exe to see a sample working
it'll just fill up the ee servers

post a code sample instead showing the usage
0
 
LVL 19

Accepted Solution

by:
Thommy earned 500 total points
ID: 33701466
Ok, I will not post .exe in future!!!

Here's another version of my function using "stringreplace":

function RemoveMoreThanOneSpacesBetweenWords02(s:string):string;
var
  p:integer;
begin
  s:=trim(s);
  Repeat
    p:=pos('  ',s);
    if p>0 then s := StringReplace(s, #32#32, #32, [rfReplaceAll]);
  Until p=0;

  result:=s;
end;
0
 
LVL 1

Author Closing Comment

by:hidrau
ID: 33701532
thanks very much
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 33701559
hidrau ...
you normally share poinx when 1 person gives the idea
and the other one steals the idea
0
 
LVL 22

Expert Comment

by:8080_Diver
ID: 33701902
Just out of curiosity, you reference having the data in a TABLE . . . what is the database?
If this is a SQL SERVER table, then you can execute a query to accomplish the substitution of one space for multiple spaces and it would execute a lot faster than doing it row by row.  I believe there is also a corresponding SQL function in most other databases.  
0
 
LVL 19

Expert Comment

by:Thommy
ID: 33702303
8080_Diver is right.

For example in ORACLE and SQL Server you can use the REPLACE()-function in an Update-Command to do string replacement for fixed character strings.

But if you have different strings to replace like double or triple spaces, then you either have to write a SQL function or start your update command several times to get all multi-spaces replaced by one space...

0
 
LVL 22

Expert Comment

by:8080_Diver
ID: 33702718
Thommy,
If you put the process in a stored proc and have it in a WHILE loop, you can execute it until you get 0 rows affected.  It is still a lot faster than doing it on a row by row basis. ;-)
Remember, SQL Is Your Friend.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 33704759
you actually run it until the length of the text is the same before and after the function
the number of rows doesn't need to change
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question