Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Enable commas in product strings

Avatar

Avatar
Boost 5
Level 3
shermozle
Level 3

Likes

33 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
shermozle
Level 3

Likes

33 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
shermozle
Level 3

06-12-2010

Right now, it's apparently not possible to include a comma inside a product name in SiteCatalyst.  I presume this is some hard-coded limitation inside the data processing component.  The solution is to strip commas from the source data.  This is a bad solution.  Munging data is just a bad idea.

 

I can just see someone down the track, who doesn't know the story, doing some perversion or other with the data from SiteCatalyst and wondering why the numbers don't align.  Then wasting a day or more before realising that the SiteCatalyst data, unlike the source data, doesn't contain commas.  

 

In this instance, the data I'm talking about is movie titles.  "Crouching Tiger, Hidden Dragon".  "Synedoche, New York".  Commas are pretty common in movie titles, and are really an integral part of the data.

 

Sure, I could use a unique identifier and then use SAINT classifications blah blah blah.  Yet another automated upload process to monitor and make sure it doesn't break and stay in-sync.  Sorry, but I've got enough of that pain already.

 

Easiest solution?  Give us an escape character that's ignored all the way through until the point when the product string is split into an array.  "Crouching Tiger, Hidden Dragon" becomes "Crouching Tiger,, Hidden Dragon" or "Crouching Tiger\, Hidden Dragon" or whatever escaping mechanism you choose.  Just choose one and tell us!

1 Comment

Avatar

Avatar
Establish
Level 1
wellfleetOyster
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Establish
View profile

Avatar
Establish
Level 1
wellfleetOyster
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Establish
View profile
wellfleetOyster
Level 1

29-04-2021

If it's not possible allow commas in product strings, an indicator of this data error would be useful.