Solved

Saving ListView Items to String (and Restoring ListView Items from String) ????

Posted on 2008-10-25
8
619 Views
Last Modified: 2011-10-19
I allow my users to build a filter string, from a form. They seelct combobox items and enter values in edit boxes, and click the add button to add the filter criteria to a ListView control (3 columns).

Field, Operator, Value

Example:  Year = 2008

The problem is, that the third colum could have values which include a space in the string

example:  Finish = Antique Silver

When there is a space, things get truncated and i loose half of the string

see code snipplets
function ListViewToFilter(LV: TListView): String;

var

  Items: TStringList;

  I: Integer;

  Part1, Part2, Part3: String;

begin

  Items := TStringList.Create;

  for I := 0 to LV.Items.Count - 1 do

  begin

   Part1:= LV.Items[I].Caption;

   Part2:= LV.Items[I].SubItems[0];

   Part3:= LV.Items[I].SubItems[1];

   if Part3 = '' then Part3:= QuotedStr(Part3);

   Items.Add(Part1 +',' + Part2 + ',' + Part3);

  end;

  result:= Items.Text;

end;
 

procedure FilterToListView(FStr: String; LV: TListView);

var

 SL, RL: TStringList;

 LI: TListItem;

 I: Integer;

begin

 SL:= TStringList.Create;

 SL.Text:= Copy(FStr, 2, pos(']', FStr)-2);

 LV.Items.Clear;

 for I:= 0 to SL.Count-1 do

 begin

  LI:= LV.Items.Add;

  RL:= TSTringList.Create;

  RL.CommaText:= SL[I];

  LI.Caption:= RL[0];

  LI.SubItems.Add(RL[1]);

  LI.SubItems.Add(RL[2]);

  RL.Free;

 end;

 SL.Free;

end;

Open in new window

0
Comment
Question by:geocoins-software
  • 6
8 Comments
 
LVL 15

Expert Comment

by:mikelittlewood
Comment Utility
That is because you set the value sl.text, it sees the space as a new word and adds a second entry for it.
0
 

Author Comment

by:geocoins-software
Comment Utility
yes, i figured it was that - and i tried CommaText, but it doesn't work either.

Do you have a fix?
0
 
LVL 36

Accepted Solution

by:
Geert Gruwez earned 500 total points
Comment Utility
use Delimited Text and AnsiDequotedStr
and use 2 StringLists to inflate or deflate
function ListViewToFilter(LV: TListView): String;

var

  Filter: Items: TStringList;

  I: Integer;

begin

  Filter := TStringList.Create;

  try

    Items := TStringList.Create;

    try

      Items.Delimiter := ';';

      for I := 0 to LV.Items.Count - 1 do

      begin

        Items.Clear;

        Items.Add(QuotedStr(LV.Items[I].Caption)));

        Items.Add(QuotedStr(LV.Items[I].SubItems[0]));

        Items.Add(QuotedStr(LV.Items[I].SubItems[1]));

        Filter.Add(Items.DelimitedText);

      end;

    finally

      FreeAndNil(Items);

    end;

    result:= Filter.Text;

  finally

    FreeAndNil(Filter);

  end;

end;

 

procedure FilterToListView(FStr: String; LV: TListView);

var

 SL, RL: TStringList;

 LI: TListItem;

 I: Integer;

begin

  LV.Items.Clear; 

  SL:= TStringList.Create;

  try

    SL.Text := FStr; 

    RL:= TSTringList.Create;

    try

      RL.Delimiter := ';';

      for I:= 0 to SL.Count-1 do

      begin

        RL.DelimitedText := SL[I];

        LI:= LV.Items.Add;

        LI.Caption:= AnsiDequotedStr(RL[0]);

        LI.SubItems.Add(AnsiDequotedStr(RL[1]));

        LI.SubItems.Add(AnsiDequotedStr(RL[2]));

      end;

    finally

      FreeAndNil(RL);

    end;

  finally

    FreeAndNil(SL);

  end; 

end;

Open in new window

0
 

Author Comment

by:geocoins-software
Comment Utility
Geert_Gruwez:

I have posted screenshots of your code in action

Screenshot 1 is what the filter string would look like stored in the registry after using the

ListViewToFilter

Screenshot2 is what the ListView would look like after using the

FilterToListView

thanks



screenshot1.jpg
screenshot2.jpg
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:geocoins-software
Comment Utility
Should look like this
screenshot3.jpg
0
 

Author Comment

by:geocoins-software
Comment Utility
Geert_Gruwez:

Disregard my last two comments. I found a bug on my side....i will get back to you

0
 

Author Closing Comment

by:geocoins-software
Comment Utility
GREAT!  Thanks.
0
 

Author Comment

by:geocoins-software
Comment Utility
I am creating another question related
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

743 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now