Jump to content

malmazan

Registered Users - Approved
  • Posts

    4
  • Joined

Converted

  • FusionPro Products
    No

malmazan's Achievements

Newbie

Newbie (1/14)

  • First Post Rare
  • Week One Done
  • One Month Later
  • One Year In
  • Conversation Starter Rare

Recent Badges

10

Reputation

  1. To elaborate and revive this thread, I am having the same issue but the code Dan posted isn't working for me. I've played around with it quite a bit and think I must be missing something obvious here. I have the fields: First Name Last Name Title In my variable text is set up as so: «First Name» «Last Name», «Title» Not every name has a title, so I want to remove the comma when the Title field is empty. The code I was using is: return Field("Title") ? ", " + Field("Title") : ""; Help please! Mariah
  2. Eric -- THANK YOU SO MUCH. This Thanksgiving, I am thankful for you! I did have a bit of clean up to do in the database, but nothing a find-and-replace doesn't fix quickly. I will keep this code forever! Thanks for your help and quick reply! Mariah
  3. Hi all! I'm super new to this -- -- I just went to training in early November and this is literally my second time using FusionPro for a real job -- so if this has already been answered please direct me to the right thread as I cannot find it. I'm not even sure it's possible. The CSV file I have for my job has one "Name" field and within that field, the names are formatted as such: "ADAMS, MARGO" and I want that to return "Margo Adams". I was able to use a basic rule to fix the all caps problem, but I have NO CLUE on what javascript to write to force anything after the comma to go first and anything before the comma to go last then delete the comma. I think I need the JS to include the Title Case functionality as well as the correct formatting functionality, correct? It seems like this might be a fairly common issue with customer-provided lists, so if it's not possible, I'm A-OK with telling the customer to fix their formatting. Thanks so much for your help!
×
×
  • Create New...