Post reply

Customer Names Mixed up..

  • April 27, 2011 at 9:37 pm

    #239230

    Hi, i was wondering if someone could help me with a problem i am having.

    I have customer names that appear in my table like so

    first_name middle_name last_name

    lastname firstname middlename

    lastname firstname

    lastname

    firstname lastname

    i was wondering what the code would be to change this to normal

    first_name middle_name last_name

    firstname middlename lastname

    seeing as all customers have differnt names i cant think of a way

    Thanks

  • April 27, 2011 at 9:52 pm

    #1317015

    It would help great up if you show the real data, as in, mock-up of ur real data instead of the column names.. and also all the columns in the table...

  • April 27, 2011 at 10:20 pm

    #1317022

    i cant seem to get a picture of the data up

    but basically i added 3 tables together, the customers were under 4 columns:

    first_name, middle_name, last_name, customer_name

    i transfered them all into

    first_name, middle_name, last_name

    but some of the names were backwards so they went into the wrong columns.. i cant change the original data so i need to find out a command to change the ones that went into the wrong columns, there was only 1, but i figured i may as well find a code to change it from happening again. the ones in the wrong columns are:

    John I Doe (not orginial)

    first_name, middle_name, last_name

    Doe, john, i

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply