Hi, I want to replace ticks in text with other text. This method usually works, but when adding three dots, I get php warning ltrim(): Invalid '..'-range, no character to the right of '..' or invalid range needs to be incrementing. I don't know where to look for error, except deleting dots. Here is the code: $code = "some text before block ´´´´code block1´´´´ text after block ´´´´code block2...´´´´"; // I want ticks to be replaced to this: <pre><code> code block1 </code></pre> $pattern = "´´´´"; // we are using ticks $countCodeBlock = substr_count($code, $pattern); // count how many times pattern …

Member Avatar
Member Avatar
+0 forum 4

Hi, I originally created this query to get a result from a single select statement Its funny that it became a very long query having sets of joined table Its also maybe annoying to look for it so im trying to trim it down most of it have same joined tables only that it accepts different parameter or value and some have some column condition (i,e.. either "1" value or "2" in a column) I still post this hoping somebody could help me trim it down and not laugh at me :) by the way, the problem of this long …

Member Avatar
Member Avatar
+0 forum 7

I have linklabel which has spaces at the end, I want to copy the label's content without the spaces. This copies the linklbl with spaces at the end: Clipboard.SetText(E_mailLinkLabel.Text) But couldn't figure out how to trim the linklabel before copying it.

Member Avatar
Member Avatar
+0 forum 1

Hi People.... I have a table named 'csv_data_table' and it has a varchar(255) column named 'EMAIL' This EMAIL column has multiple records with white spaces (at front and end) I tried this way to eliminate the white space UPDATE csv_data_table SET EMAIL = trim(EMAIL); But it won't work.... the email values still have trailing blank spaces. anyone know of a solution?

Member Avatar
Member Avatar
+0 forum 6

I have problems cleaning up a couple of input field. I've been pecking away at this issue since I wrote the application about 18 months ago. When I think I have it cleaned up; it pops up again, when users violate rules (as they often will do) and the extra spaces and tabs show up. I have a form that is filled via Copy from an excel file (this is a requirement) and pasted into the textarea: <textarea name="header_fields" cols="60" rows="6"><?php if(!empty($error)) {echo $varAllText;} ?></textarea> When the form is processed, the field is received via the following: $varAllText = trim($_POST['header_fields']); …

Member Avatar
Member Avatar
+0 forum 1

I have a csv file with lines like this example: 14," APPLES, GRANNY SMITH 72 CT usa, Case",101-016,40.00,7/16/2013,7/22/2013 14," APPLES, GRANNY SMITH 72 CT, Each",010-017,0.60,7/16/2013,7/22/2013 I need to do a few things here - I need to remove any surrounding quotes from around fields; I also need to split the third field into two separate fields; lastly I need to change the field separator from comma to tab. For example the two example lines above should end up looking like this: 14\tAPPLES, GRANNY SMITH 72 CT usa\tCase\t101-016\t40.00\t7/16/2013\t7/22/2013 14\tAPPLES, GRANNY SMITH 72 CT\tEach\t010-017\t0.60\t7/16/2013\t7/22/2013 I am new to Python and am having …

Member Avatar
Member Avatar
+0 forum 1

Hi all, With BIDS (Business Intelligence Development Studio)/SSIS, I have a process that downloads zipped CSV files. I store the files using the naming convention from the source ie 03260020-eng.csv. In a script task using BIDS, I would like to rename the file to exclude "-eng" but I'm not sure how to go about this. I have an idea to use a Right Trim but am unsure about the syntax. Can someone guide me with this?

Member Avatar
Member Avatar
+0 forum 8

I will give a training tomorrow. And the video I want to show in the training is just a little story from a movie. I want to trim the video on my Mac computer and just leave that story. Can anyone tell me how to do this? Thanks!!!

Member Avatar
Member Avatar
-1 forum 3

Not sure if this is the right section ... but is seemed the most appropriate for this topic. I need a video script that trims a video. Example: I have a video that has 3 minutes. I need the script to trim and save from the original video as many video as it can with the length of: 2.59,2.58,2.57, etc But I want this feature to be automatically. So I upload the file or select the file and after work is done I see 100 video saved. Also a good option would be that I could set up the time …

Member Avatar
Member Avatar
+0 forum 1

i need to trim a student id below is my php code <?php $stud_id ='MCC-2011-2012-0001' //what is the code to remove the MCC-2011-2012- so that i can retrieve the 0001 //or code to remove the first 14 characters echo $stud_id; ?> //thanks a lot...:)

Member Avatar
Member Avatar
+0 forum 2

Hi Guys, I am currently working on a vb project. What I am trying to do is reading a XML file and saving all the data in to the Access DB. Once this is done, I read the data from the access Db and display it in the required fields in VB form. Issue is, when i store the value in the access, a weird character is assigned before and after the data. The character is a square box with question mark in it. Also the same character displays on the VB form as well Please help me how can …

Member Avatar
Member Avatar
+0 forum 6

How do I trim my values in a gridview edit form before they are updated or inserted into the database? I want to be sure that users do not add extra spaces onto the end of the text or at the begining.

Member Avatar
Member Avatar
+0 forum 7

Hi guys!! I've to make a program that reads an arithmetical sentence from a textbox, e.g 12.3*34+4*5-3 and then on another textbox identify and display what is the content of the first textbox, for example taking the last ex: If I have this input: 12.3*34+4*5-3 The output should look like this: <number>12.3 <operator> * <number> 34 <operator> + <number> 4 <operator> * <number> 5 <operator> - <number> 3 This program should only read this operators like (+,-,*,/). I'm have in mind 2 ways of doing it, one with regex and the other taking the first sentence, put it on an …

Member Avatar
Member Avatar
+0 forum 3

The End.