Results 1 to 6 of 6
  1. #1
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    Reno, NV
    Posts
    856
    Question for MS Excel Guru's
    Hi,

    OK. I have a datafeed spreadsheet from TravelNow. Slight problem - it doesn't contain links to the individual properties. Instead, it gives the hotel ID #, which you then add onto your generic affiliate link - such as http://www.ian.com/cid=XXXXX (where XXXX is your publisher ID number).

    A final link, which goes to a hotel property, will look like http://www.ian.com/cid=XXXXX&HotelID=XXXXX

    In the datafeed, there is a dedicated column fot the HotelID field. (Column A)

    I then inserted a blank line into the datafeed and put in the generic affiliate link information. (Column B)

    So what I need to do is to find someway to append the information in Column A to the end of the information in Column B.

    How can I do that??

    Thanks.

    Jim

  2. #2
    notary sojac Herb ԿԬ's Avatar
    Join Date
    January 18th, 2005
    Location
    Central/Western NY State
    Posts
    7,741
    Lightbulb
    I'm not sure this is the solution you want, but if you just need the order of the columns changed, select on and copy each column to a new worksheet in the order you want.

    I've done this when taking a datafeed and just making a list of text links out of it.

  3. #3
    ABW Ambassador danay's Avatar
    Join Date
    March 25th, 2005
    Location
    Ft. Lauderdale, FL
    Posts
    701
    you can use the CONCATENATE function in excel to join a bunch of text strings.

    For example, if you want to join column a's text with that of column b, your formula will look like this:

    =CONCATENATE(A1,B1)

    I hope that helps.
    Danay @ LunaSolMedia.com
    Global Perfomance Marketing. Global Niche Markets = Opportunity!
    HispanicYa!|MallFreebies

    I dwell in possibility. ~Emily Dickinson

  4. #4
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    A shorter version of Danay's code:

    Create a new column c? or whereever and put this in there:
    =A1&B1
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  5. #5
    Beachy Bill's Avatar
    Join Date
    November 20th, 2005
    Posts
    8,266
    Quote Originally Posted by jimh009
    Instead, it gives the hotel ID #, which you then add onto your generic affiliate link - such as http://www.ian.com/cid=XXXXX (where XXXX is your publisher ID number).

    A final link, which goes to a hotel property, will look like http://www.ian.com/cid=XXXXX&HotelID=XXXXX

    In the datafeed, there is a dedicated column fot the HotelID field. (Column A)

    I then inserted a blank line into the datafeed and put in the generic affiliate link information. (Column B)

    So what I need to do is to find someway to append the information in Column A to the end of the information in Column B...
    I am no Excell guru - I seldom use it. What I do is to form the link in my page's PHP code and then just append the HotelID=XXXXX to the code within the page. That provides more flexibility in case you want to add some other variables into the link.

    Here is a snippet of code I use on a hotel site. It is with a different supplier (IHS) but works exactly the same way: I pull the HotelID string ($hotelID) from the database; then...

    // Let's try building the hotel link to IHS (my own corny comment)
    $HotelLink = ("http://www.MyHotelSite.com/h/hotelAvailAll.do?pfs=XXX&hotelID=.$HotelID")

    I am not really a programmer either, but somehow I get it to work. I'm sure there are more efficient ways than the one I use. But it does work. Here is an actual link from another hotel site--where I use a CName to hide their server; but the link is formed exactly the same way:

    http://hotel.MyOtherSite.com/index.j...hotelID=XXXXXX
    where the XXXXXX can be appended to the link with .$HotelID

    (Believe it or not, these CName links actually do get indexed.)

    Funny thing. I have sites built from property databases from three "other" hotel companies, but with IAN (TravelNow/Hotels/Expedia) I find that I have just been using their pages with my co-branding. Less efficient, but I get several bookings with them every day.

    If you get in the right niche, hospitality can be quite rewarding.
    Bill / Marketing Blog @ 12PM - Current project: Resurrecting my "baby" at South Baltimore..
    Cute Personal Checks and Business Checks
    If you are too busy to laugh you are too busy.

  6. #6
    Chick with Brains Tracy's Avatar
    Join Date
    January 18th, 2005
    Location
    Polk County, Florida
    Posts
    1,878
    A shorter version of Danay's code:

    Create a new column c? or whereever and put this in there:
    =A1&B1
    That's backwards. That would put the property number before the url.

    Another way to do it, without adding a column c, would be to put this formula in each of the cells in Column B:


    ="http://www.ian.com/cid=XXXXX&HotelID="&A1

    The result would be

    http://www.ian.com/cid=XXXXX&HotelID=89784

    or whatever the property number is.

  7. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Can you help with an Excel question?
    By zimmy in forum Midnight Cafe'
    Replies: 2
    Last Post: June 17th, 2006, 05:59 PM
  2. Excel question
    By SSanf in forum Programming / Datafeeds / Tools
    Replies: 9
    Last Post: February 6th, 2006, 04:25 PM
  3. Excel/Datafeed Question
    By windowsguy in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: April 20th, 2004, 01:46 PM
  4. Excel question
    By netsu in forum Midnight Cafe'
    Replies: 2
    Last Post: January 31st, 2004, 07:31 PM
  5. Excel Question
    By ~Michelle in forum Midnight Cafe'
    Replies: 2
    Last Post: January 21st, 2004, 02:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •