Search code examples
databasedelphiparadox

Pulling Text From a Memo Box Line by Line

I need to go through a ton of data that is stored in a paradox table within a Memo field. I need to process this data line by line and process each line.

How can I tell Delphi to fetch each line in the memo field one by one?

Could I use #13#10 as a delimiter?

Solution

  • Assuming that what is in the memo field uses #13#10 as the line separator then I would use a TStringList, and the very useful Text property to split the memo field text into separate lines:

    var
  StringList: TStringList;
  Line: string;
.....
StringList.Text := MemoFieldText;
for Line in StringList do
  Process(Line);

    Even if your memo field uses Unix linefeeds then this code will interpret the memo field correctly.