Assuming characters is required, the following 52 results were found.
-
This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
you are sending are not in the right format. {"code":15,"message":"Please ensure that the attachment has less than 100 characters."}: The attachment parameter is populated with the file content instead of the internal file name....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to Ragged Right (I had been setting it to "fixed width" but then got problems with it not understanding the last two characters on the row (CR & LF). Fixes of interest: -- assuming This_Decimal="00000.00" or "123456.78" (Do NOT use "Replace" and instead...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
U (for Uppercase) L (for Lowercase) A (for AlphaNumeric) X (for Alphanumeric with upper case alphabets) P (for Printable characters only) Usage select dbms_random.random from dual; -- yields random number, eg. 68489408 select dbms_random.value from...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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. Unfortunately, the MS Excel software adds tab characters to delimit...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
files only. /FAT :: create destination files using 8.3 FAT file names only. /256 :: turn off very long path (> 256 characters) support. /MON:n :: MONitor source; run again when more than n changes seen. /MOT:m :: MOnitor source; run again in m minutes...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
App". Service LinkName: Not sure what this is used for but I enter the same name in lowercase and replacing special characters with an underscore. eg. "the_joel_lipman_app" Authentication Type: set this to "oauth2" Param Type: set this to "Header" Grant...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
and press the return/enter key. Give the project a name: eg. “joels_awesome_app” (without the double-quotes and no funny characters). It will initialize a project in a folder called something like “/Users//joels_awesome_app” It will then initialize some...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
+ v_QuoteRef + ""; // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML = v_RelatedListXML + "" + v_DateTill + ""; v_RelatedListXML = v_RelatedListXML + "" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Because of MS Windows 11 limitations (any MS OS really), you need to ensure that long hyphens (#151) and some other funny characters are replaced out as the OS won't allow the file to be sent to a compressed folder. the Import process Simply login to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
be used in the listview). Add a multi-line field called "Content" and change the properties on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page where you enter the deluge code):...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with the name "Joels Image Library". I think I closed it and reopened it but now I want a 2nd...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
// // generate XML related list response // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML = v_RelatedListXML + "" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to the name of your new template (eg. affinity - Please, please, please do NOT include underscores or other special characters... keep it alphanumeric) Now upload the template you just renamed into your phpBB3 styles folder: /phpBB3/styles/. You can...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
"custom_field.php" and wanting to call my type "user_projects")!!! My recommendation is to remove any non-alphanumeric characters... In your component, create a PHP file in /administrator/models/fields/ (eg. "userprojects.php"). Rename "userprojects"...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of each line. function clean_cron_lines() { while read line ;...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
number and numbers just get rounded up without the prefixing zeros -- "00000" because we don't expect strings to exceed 5 characters. The Oracle Error Value Returning just the 5 digits of the oracle error code without the minus/hyphen in front. =IIF(...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *