Write a case rule with exceptions

[traba5058]

Dan,

I created a new rule in Fusion Pro and pasted in your code

var result = ToTitleCase(Field("Full Name"););
var Exceptions = [ "I", "II", "III", "IV" ];
for (var i in Exceptions)
{
    var re = RegExp("\\b" + Exceptions[i] + "\\b", "gi");
    result = result.replace(re, Exceptions[i]);
}
return result;

Now I am getting an error when I validate it:

line 1:Syntax Error: missing ) after argument list.

Can you help me?

[ThomasLewis]

There's an extra semicolon in the first line.
It should read:
var result = ToTitleCase(Field("Full Name"));

[Dan Korn]

Originally Posted by ThomasLewis

There's an extra semicolon in the first line.
It should read:
var result = ToTitleCase(Field("Full Name"));

Sorry about that. I edited my post to fix it. Here's the corrected version of the full rule:

var result = ToTitleCase(Field("Full Name"));
var Exceptions = [ "I", "II", "III", "IV" ];
for (var i in Exceptions)
{
    var re = RegExp("\\b" + Exceptions[i] + "\\b", "gi");
    result = result.replace(re, Exceptions[i]);
}
return result;

[strido]

Sorry to resurrect the thread -

I'm having a bit of an issue here, using the typical ProperCase rule:

var Var1 = "AgencyName";
return ToTitleCase(Field(Var1));

Now, we have two clients that have capital letters in their name - ABC Corporation for instance. What's the syntax so it doesn't come out Abc Corporation? I tried the exceptions listed above but couldn't get that to work.

My client only has the two companies that this is affected by, so it's really not a matter of listing out every possible permutation. We'll be notified if any new ones arise, so it'll just be a matter of plugging them in.

Long story short, I'd like the ProperCase to continue, just not when the letters ABC are involved....

[ThomasLewis]

Using an array the way Dan suggested is the easiest to manage when there are a lot of variables or when you know you'll be adding more in the future.

If you have a few static values you are dealing with or if you don't want to deal with arrays and loops you can use a simple if/else rule:

var Var1 = Field("AgencyName").toLowerCase();

if (Var1 == "abc corporation")
	return "ABC Corporation";
else if (Var1 == "pti")
	return "PTI";
else
	return ToTitleCase(Var1);

In this case I am pre-converting the Field value to lowercase then checking just to be safe as it has to be an exact match.

[strido]

That didn't seem to want to work....



I'm still getting the first letter Upper Case and the 2nd Lower. It should say "MW" both upper....

[ThomasLewis]

As stated, it has to be an exact match to the entire string, the only exception being that it's all going to be in lowercase to get around any inconsistencies with case.

if (Var1 == "mw financial")
	return "MW Financial";

mw Financial, Mw financial, MW Financial, would all work because they are forced to lowercase before being compared to == "mw financial".

The misspelled "mw finacail" would not work. You would have to put in another else if to handle misspellings. This is where Dan's suggestion of using an array and loop would be preferable as you could add in lots of variants easily.

Alternatively you could do something like this:

if (Var1.substring(0,3) == "abc")
	return "ABC Corporation";
else if (Var1.substring(0,2) == "mw")
	return "MW Financial";

This just checks for a match of the first few characters and doesn't worry about anything after. So the misspelling later in the word would still be a match. The only problem with this would be if you had a few agencies that started with the same letters.

[strido]

That'll do! Thanks!