?
Solved

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

Posted on 2008-10-25
8
Medium Priority
?
657 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
8 Comments
 
LVL 15

Expert Comment

by:mikelittlewood
ID: 22805672
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
ID: 22805688
yes, i figured it was that - and i tried CommaText, but it doesn't work either.

Do you have a fix?
0
 
LVL 38

Accepted Solution

by:
Geert Gruwez earned 2000 total points
ID: 22806130
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:geocoins-software
ID: 22807366
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
 

Author Comment

by:geocoins-software
ID: 22807426
Should look like this
screenshot3.jpg
0
 

Author Comment

by:geocoins-software
ID: 22807464
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
ID: 31510028
GREAT!  Thanks.
0
 

Author Comment

by:geocoins-software
ID: 22807539
I am creating another question related
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month13 days, 19 hours left to enroll

801 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