Forum Discussion
DonLarson
3 years agoQrew Elite
@Mark Shnier (Your Quickbase Coach)
I need this earlier today and I am really grateful. I have pushed to GitHub so anybody can download or pull it.
https://github.com/mcfindustries/Magic/blob/master/Community/Replace%20Characters.quickbase
ā
------------------------------
Don Larson
------------------------------
I need this earlier today and I am really grateful. I have pushed to GitHub so anybody can download or pull it.
https://github.com/mcfindustries/Magic/blob/master/Community/Replace%20Characters.quickbase
ā
------------------------------
Don Larson
------------------------------
JimHarrison
3 years agoQrew Champion
I added more values
var text RawOne= URLEncode([Scope Change Description]);
var text ReplaceHorizontalTab= SearchAndReplace($RawOne, "%09", " ");
var text ReplaceLineFeed= SearchAndReplace($ReplaceHorizontalTab, "%0A", "<br>");
var text ReplaceCarriageReturn= SearchAndReplace($ReplaceLineFeed, "%0D", "<br>");
var text ReplaceSpace= SearchAndReplace($ReplaceCarriageReturn, "%20", " ");
var text ReplaceExclamation= SearchAndReplace($ReplaceSpace, "%21", "!");
var text ReplaceQuote= SearchAndReplace($ReplaceExclamation, "%22", "\"");
var text ReplaceHash= SearchAndReplace($ReplaceQuote, "%23", "#");
var text ReplaceDollar= SearchAndReplace($ReplaceHash, "%24", "$");
var text ReplacePercent= SearchAndReplace($ReplaceDollar,"%25", "%");
var text ReplaceAmphersand= SearchAndReplace($ReplacePercent,"%26","&");
var text ReplaceSingleQuote= SearchAndReplace($ReplaceAmphersand,"%27", "'");
var text ReplaceLeftRoundBracket= SearchAndReplace($ReplaceSingleQuote,"%28", "(");
var text ReplaceRightRoundBracket= SearchAndReplace($ReplaceLeftRoundBracket,"%29", ")");
var text ReplaceStar= SearchAndReplace($ReplaceRightRoundBracket,"%2A","*");
var text ReplacePlus= SearchAndReplace($ReplaceStar,"%2B", "+");
var text ReplaceComma= SearchAndReplace($ReplacePlus, "%2C", ",");
var text ReplaceSlash= SearchAndReplace($ReplaceComma,"%2F", "/");
var text ReplaceColon= SearchAndReplace($ReplaceSlash,"%3A",":");
var text ReplaceSemiColon= SearchAndReplace($ReplaceColon,"%3B", ";");
var text ReplaceLT= SearchAndReplace($ReplaceSemiColon,"%3C","<");
var text ReplaceEquals= SearchAndReplace($ReplaceLT,"%3D", "=");
var text ReplaceGT= SearchAndReplace($ReplaceEquals,"%3E",">");
var text ReplaceQuestion= SearchAndReplace($ReplaceGT,"%3F","?");
var text ReplaceAT= SearchAndReplace($ReplaceQuestion,"%40","@");
var text ReplaceLeftSquareBracket= SearchAndReplace($ReplaceAT,"%5B", "[");
var text ReplaceBackSlash= SearchAndReplace($ReplaceLeftSquareBracket,"%5C","\\");
var text ReplaceRightSquareBracket= SearchAndReplace($ReplaceBackSlash,"%5D", "]");
var text ReplaceCaret= SearchAndReplace($ReplaceRightSquareBracket,"%5E", "^");
var text ReplaceBackTick= SearchAndReplace($ReplaceCaret,"%60", "`");
var text ReplaceLSingleQuote= SearchAndReplace($ReplaceBackTick,"%91", "'");
var text ReplaceRSingleQuote= SearchAndReplace($ReplaceLSingleQuote,"%92", "'");
var text ReplaceLQuote= SearchAndReplace($ReplaceRSingleQuote,"%93", "\"");
var text ReplaceRQuote= SearchAndReplace($ReplaceLQuote,"%94", "\"");
var text ReplaceNDash= SearchAndReplace($ReplaceRQuote,"%96", "-");
var text ReplaceMDash= SearchAndReplace($ReplaceNDash,"%97", "-");
var text ReplaceMiddleDot= SearchAndReplace($ReplaceMDash,"%B7", "-");
var text ReplaceFractionOnHalf= SearchAndReplace($ReplaceMiddleDot,"%BD", "1/2");
$ReplaceFractionOnHalf
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
var text RawOne= URLEncode([Scope Change Description]);
var text ReplaceHorizontalTab= SearchAndReplace($RawOne, "%09", " ");
var text ReplaceLineFeed= SearchAndReplace($ReplaceHorizontalTab, "%0A", "<br>");
var text ReplaceCarriageReturn= SearchAndReplace($ReplaceLineFeed, "%0D", "<br>");
var text ReplaceSpace= SearchAndReplace($ReplaceCarriageReturn, "%20", " ");
var text ReplaceExclamation= SearchAndReplace($ReplaceSpace, "%21", "!");
var text ReplaceQuote= SearchAndReplace($ReplaceExclamation, "%22", "\"");
var text ReplaceHash= SearchAndReplace($ReplaceQuote, "%23", "#");
var text ReplaceDollar= SearchAndReplace($ReplaceHash, "%24", "$");
var text ReplacePercent= SearchAndReplace($ReplaceDollar,"%25", "%");
var text ReplaceAmphersand= SearchAndReplace($ReplacePercent,"%26","&");
var text ReplaceSingleQuote= SearchAndReplace($ReplaceAmphersand,"%27", "'");
var text ReplaceLeftRoundBracket= SearchAndReplace($ReplaceSingleQuote,"%28", "(");
var text ReplaceRightRoundBracket= SearchAndReplace($ReplaceLeftRoundBracket,"%29", ")");
var text ReplaceStar= SearchAndReplace($ReplaceRightRoundBracket,"%2A","*");
var text ReplacePlus= SearchAndReplace($ReplaceStar,"%2B", "+");
var text ReplaceComma= SearchAndReplace($ReplacePlus, "%2C", ",");
var text ReplaceSlash= SearchAndReplace($ReplaceComma,"%2F", "/");
var text ReplaceColon= SearchAndReplace($ReplaceSlash,"%3A",":");
var text ReplaceSemiColon= SearchAndReplace($ReplaceColon,"%3B", ";");
var text ReplaceLT= SearchAndReplace($ReplaceSemiColon,"%3C","<");
var text ReplaceEquals= SearchAndReplace($ReplaceLT,"%3D", "=");
var text ReplaceGT= SearchAndReplace($ReplaceEquals,"%3E",">");
var text ReplaceQuestion= SearchAndReplace($ReplaceGT,"%3F","?");
var text ReplaceAT= SearchAndReplace($ReplaceQuestion,"%40","@");
var text ReplaceLeftSquareBracket= SearchAndReplace($ReplaceAT,"%5B", "[");
var text ReplaceBackSlash= SearchAndReplace($ReplaceLeftSquareBracket,"%5C","\\");
var text ReplaceRightSquareBracket= SearchAndReplace($ReplaceBackSlash,"%5D", "]");
var text ReplaceCaret= SearchAndReplace($ReplaceRightSquareBracket,"%5E", "^");
var text ReplaceBackTick= SearchAndReplace($ReplaceCaret,"%60", "`");
var text ReplaceLSingleQuote= SearchAndReplace($ReplaceBackTick,"%91", "'");
var text ReplaceRSingleQuote= SearchAndReplace($ReplaceLSingleQuote,"%92", "'");
var text ReplaceLQuote= SearchAndReplace($ReplaceRSingleQuote,"%93", "\"");
var text ReplaceRQuote= SearchAndReplace($ReplaceLQuote,"%94", "\"");
var text ReplaceNDash= SearchAndReplace($ReplaceRQuote,"%96", "-");
var text ReplaceMDash= SearchAndReplace($ReplaceNDash,"%97", "-");
var text ReplaceMiddleDot= SearchAndReplace($ReplaceMDash,"%B7", "-");
var text ReplaceFractionOnHalf= SearchAndReplace($ReplaceMiddleDot,"%BD", "1/2");
$ReplaceFractionOnHalf
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------