Results 1 to 13 of 13
  1. #1
    Newbie
    Join Date
    January 18th, 2005
    Posts
    35
    The categories in the feed I'm using have them, and in some cases I'd rather not remove them by hand. Is there a good way to do this with WebMerge?

  2. #2
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    England
    Posts
    4,327
    Use find and replace in Excel

  3. #3
    Full Member
    Join Date
    January 18th, 2005
    Posts
    413
    There are a couple of options:

    1) Use the Find and Replace command in Excel (or WordPad) to replace each occurance of "/" with another character like "&" or "-" or "and".

    2) Use the WM replace command tag in your template as follows
    [WM-FIELD: CATEGORY replace("/","-")]

    If, however, you want to use the Character field to create file names, then you need to use option one.

  4. #4
    Newbie
    Join Date
    January 18th, 2005
    Posts
    35
    ok, that is pretty much what I thought. any tips on how to deal with fractions like 5/8" that I wouldn't want to have in the file name, but would want on the page itself?

  5. #5
    Resident Genius and Staunch Capitalist Leader's Avatar
    Join Date
    January 18th, 2005
    Location
    Florida
    Posts
    12,817
    (Easy Method) Either let the page look weird and make it "5-8" everywhere, or...

    (Not so easy Method [though not really hard]) Copy the entire column to another column in a spreadsheet. Change the slashes in one column, and call the changed column for the filenames. Then use the unchanged column for the data on the pages themselves.

    Personally I found that doing it the second way got old, so now the people just get to buy "5-8" Widgets.
    There is no knowledge that is not power. ~Hemingway

  6. #6
    Newbie
    Join Date
    January 18th, 2005
    Posts
    35
    > Copy the entire column to another column in a spreadsheet

    I thought of that, but as you said I do think it would get old so I was hoping there might be another solution.

  7. #7
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by pw:
    &gt; Copy the entire column to another column in a spreadsheet

    I thought of that, but as you said I do think it would get old so I was hoping there might be another solution. <HR></BLOCKQUOTE>

    Macros come in handy for this sort of redundant thing
    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.

  8. #8
    Member
    Join Date
    January 18th, 2005
    Posts
    142
    Maybe replace the / with another unique character that doesn't occur in that field such as underscore in Excell etc.

    File names will contain -5_8-

    Then on the page use:

    [WM-FIELD: CATEGORY replace("_","/")]

    to put it back as 5/8

    I haven't tried this by the way, but it looks like it should work.

    Might try this tomorrow and check it out.

  9. #9
    Full Member
    Join Date
    January 18th, 2005
    Posts
    413
    Nice Solution!
    That should do the job just fine.

  10. #10
    Full Member
    Join Date
    January 18th, 2005
    Posts
    291
    I was experimenting with Excel, I did find /, replace (nothing) and I found it only replaced the / that stood alone. Not one 5/8 or http addy was changed.

    Lucky break for a newbie to excel!

  11. #11
    Newbie
    Join Date
    January 18th, 2005
    Posts
    21
    Hi
    Which language are you using in your website ?
    I would just make a script for that, and scape those unwanted chars, and when it's time to show in the page, just use a function to do the opposite, and you will have all as it was !!

    ***undes

  12. #12
    Full Member
    Join Date
    January 18th, 2005
    Posts
    291
    What about TM, R, % and degree signs? Geez, I can't even find them on the keyboard if I'm not in a special program. Are they allowed, or how do I replace them and with what?

  13. #13
    Full Member
    Join Date
    January 18th, 2005
    Posts
    413
    You only have to worry about special characters if they happen to be in a field that you want to use to create a filename.

    If those characters are in the description field, perhaps with HTML formatting codes, you don't need to worry about them.

  14. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. WP - Special Characters in Title
    By superCool in forum Blogging, Mobile and Social Media
    Replies: 3
    Last Post: March 12th, 2010, 02:58 PM
  2. How do I remove nonstandard characters?
    By dpl882 in forum Marketing Resources & Power Tools
    Replies: 1
    Last Post: January 20th, 2008, 08:36 PM
  3. MySQL + English Characters + Mandarin Characters
    By popdawg in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: October 8th, 2006, 01:05 PM
  4. The characters you typed were incorrect. Please try again.
    By Woz in forum Rakuten LinkShare - LS
    Replies: 1
    Last Post: August 20th, 2004, 01:07 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
  •