Solved

1 character in all words in givenname should be capitalised.

Posted on 2012-04-11
1
352 Views
Last Modified: 2012-04-11
I have a small task that I hope you guys can help me with.

I have a CSV file in the format of:

GivenName,Surname,Init,Dep,Title

Sometimes givenname is 2 names and the lastname is just 1.

I have done this (see code), but it is tease me.

If there is 1 givenname it is ok, but if there 2 givennames both names are all small.

Hope you can help me.

procedure TFrmMain.Button7Click(Sender: TObject);
var strListOrg, strLineList : TStringlist; I : integer; adComp : IADsContainer;  adUser : IADsUser;  tmp, givenname, lastname : string;
begin
  opendialog1.Filter := 'Comma Delimited (*.csv)|*.CSV';
  if opendialog1.Execute then
  begin
    if opendialog1.FileName <> '' then
    begin
      strListOrg := TStringlist.Create;
      strListOrg.LoadFromFile(OpenDialog1.FileName);
      try
        ADOQuery1.SQL.Clear;
        ADOQuery1.SQL.Text := 'SELECT sAMAccountName, mail FROM '+ Quotedstr('LDAP://OU=USERS,' + edit2.Text) + ' WHERE objectClass='+ Quotedstr('user') + ' ORDER by CN';
        ADOQuery1.Open;
        try
          for I := 0 to strListOrg.Count - 1 do
          begin
            strLineList := TStringList.Create;
            strLineList.Delimiter := ';';
            try
              strLineList.DelimitedText := stringreplace(strListOrg[i],' ','_', [rfReplaceAll]);
              if not ADOQuery1.Locate('sAMAccountName',copy(edit2.text,10,2)+copy(edit2.Text,4,2)+strLineList[2],[]) then
                if not ADOQuery1.Locate('mail', trim(lowercase(stringreplace(strLineList[0],'_',' ',[rfReplaceAll])) + '.' + lowercase(stringreplace(strLineList[1],'_',' ',[rfReplaceAll]))) + '@alfalaval.com',[]) then
                begin
                  tmp := lowercase(trim(stringreplace(strLineList[0],'_',' ',[rfReplaceAll])));
                  givenname := Uppercase(tmp[1]) + copy(tmp,2,length(tmp));
                  tmp := lowercase(trim(stringreplace(strLineList[1],'_',' ',[rfReplaceAll])));
                  lastname := Uppercase(tmp[1]) + copy(tmp,2,length(tmp));
                  tmp := Tmp ;
                end;
            finally
              strLineList.Free;
            end;
          end;
        finally
          ADOQuery1.Close;
        end;
      finally
        strListOrg.Free;
      end;
    end;
  end;
end;

Open in new window

0
Comment
Question by:QC20N
[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
1 Comment
 
LVL 22

Accepted Solution

by:
Ferruccio Accalai earned 500 total points
ID: 37831939
Change your procedure as follows
I've added a function that capitalize the first char even if there're spaces
Note that the last tmp = Tmp is not required!
procedure TFrmMain.Button7Click(Sender: TObject);
  function CapitalizeFirstChar(Name: String): String;
  var
    x: Integer;
    NextUpper: Boolean;
  begin
    NextUpper := True;
    x := 0;
    while x < length(name) do
    begin
      inc(x);
      if NextUpper then
        result := result+Uppercase(name[x])
      else
        result := result+(name[x]);
      NextUpper := name[x] = ' ';
    end;
  end;

var
  strListOrg, strLineList: TStringList;
  I: Integer;
  adComp: IADsContainer;
  adUser: IADsUser;
  tmp, givenname, lastname: string;
begin
  opendialog1.Filter := 'Comma Delimited (*.csv)|*.CSV';
  if opendialog1.Execute then
  begin
    if opendialog1.FileName <> '' then
    begin
      strListOrg := TStringList.Create;
      strListOrg.LoadFromFile(opendialog1.FileName);
      try
        ADOQuery1.SQL.Clear;
        ADOQuery1.SQL.Text := 'SELECT sAMAccountName, mail FROM '+ Quotedstr('LDAP://OU=USERS,' + edit2.Text) + ' WHERE objectClass='+ Quotedstr
          ('user') + ' ORDER by CN';
        ADOQuery1.Open;
        try
          for I := 0 to strListOrg.Count - 1 do
          begin
            strLineList := TStringList.Create;
            strLineList.Delimiter := ';';
            try
              strLineList.DelimitedText := stringreplace(strListOrg[I], ' ', '_', [rfReplaceAll]);
              if not ADOQuery1.Locate('sAMAccountName', copy(edit2.Text, 10, 2)+copy(edit2.Text, 4, 2)+strLineList[2], []) then
                if not ADOQuery1.Locate('mail', trim(lowercase(stringreplace(strLineList[0], '_', ' ', [rfReplaceAll])) + '.' + lowercase
                      (stringreplace(strLineList[1], '_', ' ', [rfReplaceAll]))) + '@alfalaval.com', []) then
                begin
                  givenname := CapitalizeFirstChar(lowercase(trim(stringreplace(strLineList[0], '_', ' ', [rfReplaceAll]))));
                  lastname := CapitalizeFirstChar(lowercase(trim(stringreplace(strLineList[1], '_', ' ', [rfReplaceAll]))));
                  //tmp := tmp; this is not required!
                end;
            finally
              strLineList.free;
            end;
          end;
        finally
          ADOQuery1.Close;
        end;
      finally
        strListOrg.free;
      end;
    end;
  end;
end;

Open in new window

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

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…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

688 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