Views
Replies
Total Likes
Views
Replies
Total Likes
Still appears to be happening. I can't think of a workaround. Did you find one??
Views
Replies
Total Likes
Thanks for re-raising this challenge. I decided to solve it.
Unfortunately, the bug preventing the REPLACE function from substituting a " " with "" has not yet been fixed:
REPLACE({name}," ","")
However...
After a transcendental meander through my Save Until Needed Vault, I am pleased to share the following workaround, as shown below:
Here is the textmode for each column:
displayname=Replace Spaces With ~
textmode=true
valueexpression=REPLACE({name},' ','~')
valueformat=HTML
displayname=Replace Spaces with New Line
textmode=true
valueexpression=REPLACE({name}," ","\\u000A")
valueformat=HTML
and last but not least, the One You're After:
displayname=Replace Spaces with Null Character
textmode=true
valueexpression=REPLACE({name}," ","\\u0000")
valueformat=HTML
Note, though, that (as I mentioned in this related post)...because these formulas leverage Unicode control characters there is a GOTCHA: "...remember to always re-supply the extra leading \ symbols that are sacrificed whenever such calculations are edited via the front end (vs pushing such calcs in via the API)."
That aside: one more down, zillions to go.
Have fun.
Regards,
Doug
Thanks for looking into this @Doug_Den_Hoed__AtAppStore
So, when I tried this as a calculated field on a custom form, this is how I had to implement it to work:
Really useful to have these two codes. Thank you.
Hopefully Workfront will resolve this bug.... (I won't be holding my breath though)
My pleasure @RobertDy,
That is encouraging that the custom form builder you used is "smart enough" to not need the double \\ prefix that the textmode editor requires (since the latter "swallows" the leading \ upon save): perhaps the dev team can use the former to expedite fixing the latter (cc @jon_chen to relay accordingly, please).
Regards,
Doug
Views
Replies
Total Likes
Hey Doug
Similar issue, I have the following calculation to create a string but I need to remove the character spaces in {name}
CONCAT(
{project}.{DE:Fiscal Year for DAM},"_",
{project}.{DE:Product},"_",
{project}.{DE:IC - Market},"_",
{project}.{DE:Segment},"_",
{DE:IC - Asset Type},"_",
{DE:Funnel},"_",
REPLACE({name}," ","\u0000"), "_",
{project}.{DE:Prospective customer industry/vertical},"_",
{DE:IC - Asset Size},"_",
{referenceNumber})
Your \0000 works in the custom form but throws an SQL error when a value is updated in the report.
Essentially I want to get this:
23_SX3_DE_SMA_10"_MOFU_SocialPostCopyOption3_AUTO_Vide_9x16_2649318
from this:
23_SX3_DE_SMA_10"_MOFU_Social Post Copy Option 3_AUTO_Vide_9x16_2649318
Wondered if you had any suggestions?
Andy
Views
Replies
Total Likes
@Doug_Den_Hoed__AtAppStore @RobertDy
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies