Re: Manipulation of strings query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: StressedMonkey (miguel_at_stressedmonkey.net-nospam)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 13:05:54 -0000

Hi Bob,

The DB is Oracle 8i I think.

I have received the data in an excel spreadsheet which contains the names in
the LASTNAME, FIRSTNAME format and was going to just import it into a table
in the DB. I don't know any way of getting excel to split a cell into 2 so
that I could enter it as 2 fields in a database and I'm certainly not doint
it manually as there are about 2000 rows!

The problem with the string input is that users will not be entering the
data on a form as such, the application performs an LDAP query agains a last
name that they enter. The query then returns the names in the Firstname
(Space) Lastname format............

Cheers.

Miguel.

"StressedMonkey" <miguel@stressedmonkey.net-nospam> wrote in message
news:404db232$0$14400$cc9e4d1f@news.dial.pipex.com...
> Hi,
>
> I'm not too hot on my manipulation of strings. I have a database which
> cintains names in the format (Upper case also) LASTNAME, FIRSTNAME
>
> I want to search against that database, but the data on the form to
produce
> the string will be input in the following format:
>
> Firstname Lastname
>
> So I will need to convert this string in the following ways:
>
> 1. Make all uppercase
> 2. Reverse the position of Firstname & Lastname
> 3. Add a comma and space between Lastname & Firstname
>
> Basically, so that the string looks exactly as the names will in the
> database.
>
> Are there any Maestro's out there that can help me with some code to
achieve
> this?
>
> Thanks.
>
> Miguel.
>
>

Relevant Pages

  • Re: [PHP] Date/time format?
    ... Jason Pruim wrote: ... I am trying to figure out what format a string is in in a database. ... Below is an example of one of the lines in the database, What I'm really interested in is how it represents the "day". ... I have not been able to find ANY info about that format, other then other people using it in blogs. ...
    (php.general)
  • Re: year to date conversion
    ... the date in ISO-format, i.e. exactly in the format the OP requested. ... It is rare to need to be database independent. ... Sure, but again, there are moments, where a PreparedStatement ... The string is created by java.sql.Date, ...
    (comp.lang.java.programmer)
  • Re: [PhP - dB] About Formatting a Date Result
    ... In the MySQL database the field is set to date not timestamp as you ... foresight has stored a string date instead of a timestamp, ... and can format your date to that used, in the config files, for any user ...
    (php.general)
  • Re: Getting entries from an SQL database with datetime parameter
    ... format is what you want. ... funtion to convert date string into date time accordig to your needs. ... your database, you will run into troubles comparing date to string. ... > hard coded a query to populate the datagrid, ...
    (microsoft.public.dotnet.framework.adonet)
  • importing Excel 2003 pro custom format into Access 2003 pro data
    ... I have a large Excel spreadsheet that I want to import into access. ... When I import it into the database it drops the leading zeros (which each ... the 000-000-000 format but that only makes it easier to retype the numbers. ... leading zero dropping off? ...
    (microsoft.public.office.misc)