Assuming character is required, the following 41 results were found.
-
A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
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: *
-
and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... What I have Me,Myself,I\na,b,c What I want Me,Myself,I a,b,c How? So in this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold down while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
to use a named pipes connection, "unix" for a Unix socket connection and "memory" to use MySQL shared memory. Specifying character set Use this one to specify which character set to use to encode queries sent to the server....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
Custom Service - on account server COM https://deluge.zoho.com/delugeauth/callback Problem: Split a string with the escape character/backslash character Trying to split a string into a list by the backslash character: v_File =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
#myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' + COLUMN_NAME + ' ' + DATA_TYPE ELSE ',' + COLUMN_NAME + ' ' + DATA_TYPE + '(' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Databases initially setup with collation 'latin1_swedish_ci' What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My company has...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
paint, palette knife, windsor & newton oil paints, award-winning style::3 signature, deformed::-2 cartoon: ::5 Whimsical character design::4 Tags: creative, expressive, detailed, colorful, stylized anatomy, high-quality, digital art, 3D rendering,...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
some point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, we take each character from the given string...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
22-Jul-2014 23-Jul-2014 24-Jul-2014 25-Jul-2014... How? To do this in a select query resultset, you insert the special character references "CHAR(10)" [line feed] and "CHAR(13)" [carriage return] but to do this in the name of the column heading, the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
photoshop Automatic Updates wuaucpl.cpl Bluetooth Transfer Wizard fsquirt Calculator calc Certificate Manager certmgr.msc Character Map charmap Check Disk Utility chkdsk Clipboard Viewer clipbrd Command Prompt cmd Component Services dcomcnfg Computer...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
What? This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other alphabets is necessary when dealing with languages...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Hello $New_World $string_formatted = preg_replace( '/\$[a-z_]+/i','$0', $string_original); Replace all words with suffixed character Convert: Hello( World ) » Hello( World ) $string_formatted = preg_replace( '/[a-z]+\(/i','$0', $string_original);...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space character and delimiting by a string. The Gist -- What I have Image00001 (Copy).jpg Image00002 (Copy).jpg -- What I want Image00001.jpg...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
pictures. If you are batch processing a text file, you need to separate the website address and the given name with a pipe character ("|" - see "TEXT file example" mentioned earlier). It ignores spaces before and after any text. If you haven't specified...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
{ English_Ordinal = Ordinal_Map.get(My_Date_Field.toString("d")); } Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in a single line, consider different methods of inserting a new line: Joel Lipman: ZohoDeluge: Inserting a new line character in a CSV
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This will contain the code triggered when one of the fields is changed Add an eTag field: Will hold a 32 hexadecimal character string / a hash of the fields to monitor Add the if statement to compare etags on your main workflow. Other fields needing to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *