Filter Format = CSV Entry - YF to handle fields with embedded commas

Josephine Mancy Abisha Micheal Fernando shared this idea 2 years ago
Completed

YF doesn't handle CSV fields with embedded commas for the CSV Entry type of Filter Formatting.


For example, if I have 2 CSV fields

"Melbourne, Victoria", "Melbourne, Florida"

then Yellowfin will interpret this as 4 separate fields.

(please see attached screenshot)


Could you please implement the functionality such that Yellowfin will allow embedded commas in CSV Fields.

Comments (6)

photo
1

Hi Mancy,


Just letting you know this item has been logged as an enhancement and currently under review.

Will let you know once there is movement, as we believe this is a feasible request, it's just a matter of working out when we can implement these changes in 7.3.


Regards,

David

photo
1

Hi Mancy,


Got some good news!

It looks like we can give you the results you were after.


As long as the values are seperated by ", then the , will be ignored.

So with the above example, "Melbourne, Victoria", "Melbourne, Florida" will be registered as only 2 values, not 4.


This change will be implemented in the 7.3 June release, which should be available on the last Friday of June.


Please let me know if you have any questions or concerns on this.


Regards,

David

photo
1

Hi David,


I have receive a notification as Status = completed. Would like to know whether this idea has been implemented?

May i know the build version?


Thanks.

photo
1

Hi Mancy,


Yup, this was fixed in June 7.3 (sorry didn't close this earlier). You can check this on our change logs:

5723 - added method handling different cases with csv string splitting

As per previous notes, as long as the values are separated by ", then the , will be ignored.So with the above example, "Melbourne, Victoria", "Melbourne, Florida" will be registered as only 2 values, not 4.


Please let me know if you have any issues or questions post upgrade.


Regards,

David

photo
1

Hi David,

Noted, will check this in Version 7.3 (20170331). Thanks.

Regards,

Mancy.

From: Yellowfin Support [mailto:support@yellowfin.bi]

Sent: Tuesday, 5 September, 2017 10:39 AM

To: Josephine Mancy Abisha Micheal Fernando (NCS) <jmancy@ncs.com.sg>

Subject: New Comment in "Filter Format = CSV Entry - YF to handle fields with embedded commas"

-- REPLY ABOe VE THIS LINE --

New Comment

a97f8bce5a9a8d00b7e84f5bf9698fe6

Filter Format = CSV Entry - YF to handle fields with embedded commas

David Registro

Hi Mancy,

Yup, this was fixed in June 7.3 (sorry didn't close this earlier). You can check this on our change logs:

5723 - added method handling different cases with csv string splitting

As per previous notes, as long as the values are separated by ", then the , will be ignored.So with the above example, "Melbourne, Victoria", "Melbourne, Florida" will be registered as only 2 values, not 4.

Please let me know if you have any issues or questions post upgrade.

Regards,

David

OPEN COMMENT IN BROWSER

idea: Filter Format = CSV Entry - YF to handle fields with embedded commas

Status: Completed

Category: Content Creation

Assigned: David Registro

Stop receiving notifications about this idea

photo
1

No problems.