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?

6 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 2 days ago

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 2 days ago

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

Please login or Register to Submit Answer