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
BedrockMission!

Learn More

View all

Sign in to view all badges

Remove newline and whitespace from values

Avatar

Avatar
Boost 50
Level 5
adamhaining
Level 5

Likes

95 likes

Total Posts

51 posts

Correct Reply

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

Avatar
Boost 50
Level 5
adamhaining
Level 5

Likes

95 likes

Total Posts

51 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
adamhaining
Level 5

25-04-2013

Occassionally data will be sent in where there is a space on the end, a tab somewhere in the value, or even a newline character.  This causes a value to appear normal in SiteCatalyst when in reality it is not.  If it were consistent, it would be fine, but sometimes it is a matter of how a browser interprets and encodes data.  This then causes 2 lines to appear in SiteCatalyst that appear the same.  To find this out I have to export as a CSV and then open in a text editor to find the problem.

 

My request is that any of these whitespace type characters be removed from data as it comes in.  This can include double spaces, tabs, newlines, and anything else that may be encountered.  This would be easy to group these values together.

 

I've code it coded now to fix this, but it seems like an unnecessary step.  Another possibility is having it handled in the JS code so the servers don't have to process this.