Get Free Trial
Get Free Trial

String auto formatting seems to be applied to all items in a single column

Christopher Phillips asked on April 25, 2019

Example CSV
“Month”,”Category”,”Revenue”
“”,””,”$708,785.00″
“January”,”Condiments”,”$5,737.50″
“January”,”Breakfast Cereals”,”$2,370.00″
“January”,”Confectionery”,”$3,687.50″
“January”,”Soups”,”$1,080.00″
“January”,”Confectionery”,”$4,477.50″
“January”,”breakfast Cereals”,”$1,580.00″
“January”,”BAKERY”,”$2,625.00″
“January”,”Bakery”,”$1,312.50″
“January”,”Fruit Preserves”,”$2,962.50″
 
In the same column we have “BAKERY” and “Bakery”. After importing this into Flexmonster all instances of “bakery” found in the column will now be displayed as “BAKERY”
 
Is this expected behavior?

9 answers

Public
Vera Didenko Flexmonster April 26, 2019

Hello, Christopher, 
 
Thank you for your question.
 
We would like to confirm that this is the expected behavior. 
When two same values are detected differing from one another only by case, then out of both values Flexmonster chooses the one which was encountered first.
 
So, in your case, “BAKERY” was encountered first, hence all other values of “bakery”, “Bakery”, “BAKERY”,…. will be grouped under “BAKERY”.
 
Please let us know if you have further questions.
 
Best Regards,
Vera

Public
Christopher Phillips April 26, 2019

Thanks for the response Vera, is there anyway we can maintain case sensitivity? We have a case where IDs do maintain the case sensitivity and thus are different.

Public
Patrick OFriel April 29, 2019

Yup, this is very important in cases where unique identifiers expect uniqueness based on casing, we’ve seen this with output from Salesforce. Can you provide some sort of property like ‘enforceCasing=true’

Public
Vera Didenko Flexmonster April 30, 2019

Hello, Christopher, Patrick,
 
Thank you for your reply.
 
Our team will further investigate if this feature can be added and we will notify you about the results on the 21st of May.
 
Please let us know if you have any further questions.
 
Best Regards,
Vera

Public
Vera Didenko Flexmonster May 21, 2019

Hello, Christopher, Patrick,
 
We would like to inform you that our team has looked into your request and is currently working on adding an option to maintain case sensitivity.
 
The feature will be available in the minor release with the ETA 3rd of June.
 
Please let us know if you have any further questions.
 
Best Regards,
Vera
 

Public
Patrick OFriel May 21, 2019

Thanks Vera! That’s great news, let’s us integrate with a wide variety of systems that would’ve been very difficult previously.

Public
Vera Didenko Flexmonster June 4, 2019

Hello, Christopher, Patrick,
 
We are glad to announce that a new property caseSensitiveMembers was added to distinguish members with different cases.
 
This is available in the 2.7.7 version of Flexmonster
 
You are welcome to update the component
 
Please let us know if everything works fine.
 
We are looking forward to hearing from you.
 
Best Regards,
Vera

Public
Vera Didenko Flexmonster June 5, 2019

Hello, Christopher, Patrick,
 
We would like to add that caseSensitiveMembers needs to be specified in the options the following way:

options: {
caseSensitiveMembers: true
}

 
Here is a JSFiddle example for illustration.
 

The caseSensitiveMembers parameter works the same way for CSV.

Please let us know if everything works.
 
We are looking forward to hearing from you.
 
Best Regards,
Vera

Public
Patrick OFriel June 5, 2019

Great! We’ll take a look at adding this to our application

Please login or Register to Submit Answer