Trim values along with the tabhttps://www.joellipman.com/articles/database/mysql/trim-values-along-with-the-tab.html

13 June 2016 adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Make bootstrap carousel responsive to swipehttps://www.joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 } ),this } }(jQuery); $('.carousel').bcSwipe({ threshold: 50 }); Source(s): Stack Overflow: How to make Bootstrap carousel slider use mobile left/right swipe Mark Shiraldi - Github bcSwipe

• Type: Article
• Author: Joel Lipman
• Category: Bootstrap
• Language: *

Change div height to fit contenthttps://www.joellipman.com/articles/web-development/css/change-div-height-to-fit-content.html

19 December 2016 this to happen: The code of this is the addedn overflow:hidden;height:1%;: A long heading that wraps over several lines Source(s): Stack Overflow - make div's height expand with its content

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

FTP on Mac: Failed to retrieve directory listinghttps://www.joellipman.com/articles/web-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 entering it in the remote directory field. Still no files or folders would show. There's a good bit of information from the source link listed below but the settings didn't solve the problem. The solution was to change the options on the mac firewall by...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 file (*.TXT). This will stop MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with each column: 1. Specify that the data is delimited 2....

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 = v_NextIndex.leftpad(3); // yields " 10" v_NextIndexStr = v_NextIndex.leftpad(3).replaceAll(" ", "0"); // yields "010" Source(s): Zoho Community - How to pad a string with leading zeros

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 Administrator site Go to Articles and click on Options Set Show Unauthorised Links to Yes Set Show Intro Text to Show Source(s): Joomla! Documentation - Restricting access to "read more" Search(es): joomla change permissions for read more joomla change...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *