Assuming characters is required, the following 52 results were found.
-
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
-
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
-
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
- 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
- Language: *
-
DBMS Random Referencehttps://www.joellipman.com/articles/database/pl-sql/dbms-random-reference.html
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: *
-
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: *
-
// remove BB Code and HTML tags $str = html_entity_decode( $str, ENT_QUOTES, "utf-8" ); // converts html entities into characters (symbols) $str = preg_replace("/&.{0,}?;/",'', $str); // removes numeric entities? $str = preg_replace('//i', '', $str); //...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- 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
-
SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html
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: *
-
that searched every column containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below example which outputs a...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
systems are the usual suspects. Developers will have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
LEN(@Haystack)) -- yields "3.String4" Almost there, counting backwards and forwards it seems the index is just two characters off (as I don't want to include the period): SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) + 2 -- yields...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
for this step. Click on Create Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and preferably no spaces (I tend to give it an all lowercase name with no spaces). tick the checkbox Run with highest...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- 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
-
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
-
code and then the inner SRL text which should be |, if you try to apply you should be prompted to convert to use gold characters: Test the XET export and you should get something like: 5826|England Almost! If the code and it's short name/full name exist...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it in PHP with the function simplexml_load_string()....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF