Results 1 to 4 of 4
  1. #1
    Newbie
    Join Date
    June 21st, 2007
    Posts
    2
    Replace problems
    Hi

    I'm going crazy here trying to replace all instances of "-" in my product name with a space. It's not practical to do it within a spreadsheet so I am trying to use the replace function as follows

    [WM-Field: product_name noLink raw replace("-"," ")]

    but I just end up with the hyphen being removed and all the words squashed up.

    As an aside is there any way I can download 2.4.1? I was reading in previous posts that this solves the problem with not correctly saving all the settings. The link to the download has now been removed.

    Cheers

  2. #2
    ABW Ambassador AWaR's Avatar
    Join Date
    January 18th, 2005
    Location
    Scotland
    Posts
    625
    would i be correct in saying that the space in replace("-"," ") is made by just hiting the space bar ?

    if yes, then try using this:

    replace("-"," ")

    it should do what you're looking for
    "Yesterday we obeyed kings and bent our necks before emperors. But today we kneel only to truth..." - Kahlil Gibran

  3. #3
    Newbie
    Join Date
    June 21st, 2007
    Posts
    2
    Excellent, that's done the trick!

    I owe you a beer

  4. #4
    ABW Ambassador AWaR's Avatar
    Join Date
    January 18th, 2005
    Location
    Scotland
    Posts
    625
    hey... just glad i could help out
    "Yesterday we obeyed kings and bent our necks before emperors. But today we kneel only to truth..." - Kahlil Gibran

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Replace Command
    By wow100 in forum WebMerge (Fourthworld.com)
    Replies: 1
    Last Post: November 11th, 2009, 05:48 PM
  2. How can I replace commas. Replace wont' do it
    By sotonman in forum WebMerge (Fourthworld.com)
    Replies: 8
    Last Post: April 25th, 2007, 04:37 AM
  3. replace semicolons
    By seastwood in forum WebMerge (Fourthworld.com)
    Replies: 1
    Last Post: May 11th, 2006, 06:06 AM
  4. How often do you replace your computer?
    By Paul_Ward in forum Midnight Cafe'
    Replies: 27
    Last Post: October 26th, 2005, 10:24 PM
  5. Need Help-mySQL REPLACE
    By Greg Rice in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: May 20th, 2004, 04:06 AM

Posting Permissions

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