Assuming lines is required, the following 38 results were found.
-
but if they typed a return character, the app would crash because it didn't understand the data. I tried replacing the new lines but just stopping the return key or trying to catch it is an obsolete method. How? The following example replaces the return...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
where results unmatched column_values = column_values || []; // ignore row if first item is blank (allows for blank excel lines) if(column_values[0] != ''){ // remove any/all double-quotes in this column value // found this method more reliable than...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
= v_MyString.replaceAll(("([&'\"])"),"\\$1",false); // yields Joe\'s \"Amazing\" Skill \& \ Grunt Replace new lines in returned JSON (invalid in Zoho): v_MyString = "{"MyKey":"MyValue "}"; // the long way (and cos the regex for this isn't working)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
via API (see what I did there?), we need a Zoho Oauth2 connection in Zoho Books. In Zoho Creator, go to Setup (3 horizontal lines in top left if in edit mode » pops up the side bar to go to Home or Setup) Under "Extensions", click on "Connections" Click...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a comparing if statement to all fields? Well no again, just compare on the workflow of the audit change. Something along the lines of: Add an Audit Change field: This will contain the code triggered when one of the fields is changed Add an eTag field:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Note the embed code, specifically the long alphanumeric string. Create a connection from Zoho Creator to Zoho Inventory 3 lines icon in the top-left of your Creator (in edit this application mode) Then go to Setup > Connections > Add Connection Select...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ "/documents/" + v_DocumentId + "/pdf" type :GET headers:m_Header ]; // if this doesn't work, enable one of the following 2 lines //r_File.setParamName("attachment"); //r_File.setParamName("file"); r_File.setFileName(v_DocumentName); r_Attach =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
expressive, detailed, textured, traditional medium, charcoal, high-quality paper, limited edition, award-winning, expressive lines, shaded areas, attention to detail::3 deformed, poorly executed, lack of detail, unrealistic shading::-2 emblem: ::5 Coat...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
page 1 but specifying 100 per page as the default is only 10. // // API keys (these are made up so enter your own in these 2 lines below v_MyWordPressSiteUrl = "https://mysite.com"; v_ConsumerKey = "ck_aaaabbbbccccddddeeeeffff1111222233334444";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
as I thought I covered this previously but couldn't find it on my website. This was previously titled something along the lines of truncating to 2 decimals but finance is so much more complicated. Why? Playing around with VAT / Tax, inclusive...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for the template You should be given an option of css files, select styles.css and click on the Edit button Look for these lines: body.bgstyle1 #main-background {background: url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat;} where 1 is...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
UPDATE table1 SET counter_field_value= WHERE column1='this_article' Combined with a PHP script this could be a few lines for something really small. The quick trick to this is to do it all in one query: UPDATE table1 SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you suspect might be the problem? Able to run the SQL queries directly against the database? Matched the datatypes...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
-- where -- SUBSTRING(img_timestamp, 1, 8)>=20110922 ORDER BY img_timestamp DESC Note that I've commented out the lines which specify images modified since the 22nd of September 2011. I've left it in there for my own benefit as it's unlikely I'm asked...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
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), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want:...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line: m_Custom = {"UDF_CHAR8":12345678901234567,"UDF_CHAR7":"Joel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *