[A Rule associating with a comma and suffix of a name]

Thank you, Jon! That worked like a charm.

[A Rule associating with a comma and suffix of a name]

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

[JS fix for LAST, FIRST]

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

[JS fix for LAST, FIRST]

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!