Assuming text is required, the following 124 results were found.
-
This does nothing: // add the following to your header This does nothing: // set the collation of the database and any text fields to 'utf8-general-ci' ALTER DATABASE db_name CHARACTER SET latin1 COLLATE utf8-general-ci; // set text fields to utf8 SET...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
rid of all the unnecessary extra gridlines (the ones that appear in the ruler as little arrows). So right-click on a heading text box that works Select "Size and Position..." Copy to clipboard the exact height value Right-click on a faulty heading...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the data, it acknowledges new lines (the "CHAR(10)" as with other cell data). Quite a lot of spacing (the height of one text line), but our customers were complaining it became too convoluted and cramped when refreshing data and preferred the end result...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type:...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
1.4571E+18 Stanley 1709123456 1.4571E+18 1.4571E+18 David 3.31235E+11 1.4571E+18 How? Firstly, save the CSV file as text 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...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, you can parse the multi-line into a nice HTML table. But on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
module Job Opening: Lookup to the Job Opening module (called "Vacancies" in client's system) Candidate Ref: A single line text field Vacancy Ref: Another single line text field Candidate x JobOpening Name: Mandatory name field that we will use so as to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
given it the field link name "Note_ColorPicker_Css" Add a radio field type, I've called it "Color Picker" Add a single line text field, I'm calling it "Hexadecimal" [Key field that will be used by the application later - so perhaps rename this to 'Staff...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
+ " " + v_OutputResponse + " "; // // output to new browser tab m_Response = Map(); m_Response.put("Content-Type","text/html"); m_Response.put("status_code",200); m_Header = Map(); m_Header.put("Content-Disposition","inline;");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
// Check if the response contains the expected structure let output = r_SubData?.details?.output; // If the output is JSON text, parse it into a real object let parsedOutput; try { // Attempt to parse the output as JSON parsedOutput =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a quick glance of the preview and then click on Next First row contains column names = Yes, leave everything else as plain text except for Description which you should change to a Multi Line Text. Click on Create. You should end up with something like A...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
AS a'); // Add "Relevance" column // + 1000 pts if in title x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select('...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
if len(data) == 0: break if rec.AcceptWaveform(data): result = json.loads(rec.Result()) transcript.append(result.get("text", "")) # Get final result final = json.loads(rec.FinalResult()) transcript.append(final.get("text", "")) # Save transcript with...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
out there on the web but here's an all-in-one where I Open an AlertDialog designed with a custom XML layout Set the hint text of a specific user input field (EditText) Store the input in a TextView (invisible or visible) held in the calling XML /*...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source and to populate a database table with this data. Note that this only works if all the text files to be used...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
16-Jul-2014 17-Jul-2014 18-Jul-2014 Last Step: Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get the text The clock...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get the text The clock...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
100) I'd appreciate if you bear with me as I add captions to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should be on the following screen:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB