My data was not trimmed appropriately.
Formula: trimleft([JSON_Name],"data.")
Result:
Before Trim | After Trim |
data.term | erm |
data.thank | hank |
data.therapies | herapies |
data.work | work |
data.world | world |
data.women | women |
Does anyone know how to fix this?
Thank you,
Kazumi
Solved! Go to Solution.
Per Help on Functions, TrimLeft will remove any characters specified in "y", from "x".
TRIMLEFT(x, y) Remove character in the string y from the beginning of the string x.
Since "t" is in your "y" set of data, it is trimming the "t" after the period as well.
Based on your small sample set of data, I would suggest
--REPLACING "data." with "" (in other words, replace "data." with an empty value)
--or using RegEx to keep anything after the period
--or a SUBSTRING function that starts at the 6th character
Depending on what your full set of data looks like, one of these should work.
Thank you!