What?
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.
Why?
I use MS Excel for organizing data and then converting to MySQL commands. ...
What?
Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines).
How?
First in Transact-SQL:
SELECT
RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ...
... for use in the code below
Edit the Message Handler code
ChatGTP 3.5 Turbo
//
// initialize
m_Response = Map();
l_Messages = List();
v_Message = message.trim();
//
// if the message ...
What?
This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify.
Why?
Previously, we would receive an eBay notification and create an ...
... "")
; loop until there are no more double spaces
while InStr( v_NewName, " ")
v_NewName := StrReplace( v_NewName, " ", " ")
; trim any leading/trailing spaces ...
... ) n
WHERE n.n 5
AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t')
GROUP BY `value`
ORDER BY `total` DESC
LIMIT 0,50;
Additional Note(s):
I ...
... = v_MyString.toLowerCase().trim();
v_MyFormattedString = v_MyFormattedString.replaceAll("[^a-z0-9@\-.]+","");
// yields This email address is being protected from spambots. You need JavaScript enabled to view it.
Replace any duplicates:
v_MyString = "Hello ...
... getUrlAlias($p_Name){
// lowercase and trim preceding/trailing spaces
$v_Output = strtolower(trim($p_Name));
// replace all non alphanumeric characters (except underscore) to an underscore
...
... be a full JWT: base64 encoded, URL-safe, three part string delimited by a period/dot:
// Generate assertion/signature of JWT
$api['jwt']['assertion'] = rtrim(strtr(base64_encode(json_encode($api['jwt']['header'])) ...
What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...
... XML declaration from results
$output = substr($output, stripos($output, '?>') + 2 );
// remove leading spaces, carriage returns
$output = trim($output);
// process if type specified was xml
if($apimo_type=='xml'){
...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.