Questions tagged [trim]

Trimming refers to the manipulation of a text string to remove leading and/or trailing whitespace (and/or ASCII control characters), or (optionally) a specified character.

2454 questions
0
votes
3 answers

I am generating a series of numbers delimited with space but I want to remove the space at end

I am generating the series of numbers using for loop, delimited with space but I want to remove trailing space at last. Unable to use trim() for the output. import java.util.*; public class Main { public static void main(String [] args){ …
shantz
  • 25
  • 6
0
votes
1 answer

How to catch data in react-redux when error trim is show?

I can't load post when I don't declared categories, but if I try to set default categories then I can't changes categories for another one? Somody have to Idea what to do? useSelector - Redux. const catchTaxonomies = useSelector( state => ({ …
SeN
  • 151
  • 1
  • 2
  • 11
0
votes
2 answers

Using FFMPEG to batch remove audio endings

I have over 1000 audio files, all of which end in a mouse click. I would like to remove the last half second from all of them. The audio files have different length (i.e. 15sec, 5 sec ...) But one thing in common with all of them is the last half…
user2828890
  • 1
  • 1
  • 3
0
votes
1 answer

Trim without turning some numerical values into date values Google script

I have var rangeValues = sheet.getDataRange().getValues(); // iterate through all cells in the selected range for (var cellRow = 0; cellRow < maxHeight; cellRow++) { for (var cellColumn = 0; cellColumn < maxWidth; cellColumn++) { …
xyz
  • 2,253
  • 10
  • 46
  • 68
0
votes
2 answers

Trimming a date in an object from an array and sorting the array by most recent date

I have an array of objects and I need to trim the created_at value and return the full array of objects descending by most recent created_at value. I can perform the sort as desired but my code only returns the create_at value, not the entire object…
David M.
  • 21
  • 2
0
votes
1 answer

Gridview Trim Error in ASP.NET

This is my reference question; String.Format Same Code Different View When i try this code; var cultureWithoutCurrencySymbol = (CultureInfo)CultureInfo.CurrentCulture.Clone(); …
Soner Gönül
  • 97,193
  • 102
  • 206
  • 364
0
votes
1 answer

How to Trim Headings in a table with VBA code

I'm trying to trim the headings of a table with VBA code because some of them have spaces in front that varies every month, which makes it difficult for coding. When I break down the code and run it step by step it works fine but when I run the…
Simone Evans
  • 183
  • 2
  • 17
0
votes
1 answer

Am I missing something here ? XD TrimRight does not seem to want to work

Ok, here is the small portion of code to demonstrate: CString txt = _T("Hello World"); CString txt2 = txt; txt2.TrimRight('W'); AfxMessageBox(txt2); The output is "Hello World". What am I not getting right ?
Simon
  • 277
  • 1
  • 5
  • 13
0
votes
3 answers

SAS: Delete missing items in a macro variable

I have a macro variable called list1, which gives: %put &list1.; A,B,C,D,,,G,,I,, I need to delete those items which are missing i.e empty between the commas. The final output should be like A,B,C,D,G,I. Is it possible? Trim function does not seem…
S.Paul
  • 3
  • 1
0
votes
2 answers

Trimming a substring that will be used on different length strings

So I have a string like abcdefg#3h#ijkl12mka#123456#L#5 I am trying to get only the string 123456 out of that string. Note: there are string of different length, so I cant use something like substr(21,length(string)). I do not think i can use…
user10111685
0
votes
1 answer

FFMPEG cut out group of frames

I'm looking for a command to cut out exact frames from a video. I know that I can do this by slicing the video in two and then concat, but I'm looking for a sigle command to achive the same result, something like: ffmpeg -i video.mov -cutframe…
Virgosh
  • 1
  • 1
0
votes
3 answers

How to write equations in the SELECT area

I have 2 tables that I've Joined, One contains "Materials" and the other contains "Moldings". They are joined by the Material ID. I want the end result to be a table of all of the unique materials being used. The issue I'm running into is that the…
Matt
  • 1
0
votes
1 answer

Get specific string values from XML by identifying start with and end with string variables

I am trying to cut out some of the text that an XML file gives out. I have this XML data Luqa, Malta (LMML) 35-51N 014-29E 91M
Dennis Vella
  • 21
  • 3
  • 4
0
votes
0 answers

Trim beginning and trailing spaces in Code Behind VB

I am trying to remove beginning and trailing spaces before my value is entered into the database. I tried the following but with no success and am struggling syntactically. SqlHelper.ExecuteNonQuery(SqlHelper.Command("dbo.spMYPROC_Insert",…
Andy Williams
  • 879
  • 1
  • 14
  • 33
0
votes
2 answers

How to TRIM OR TRUNCATE first character in DB2 column

I have column phone number with value and want to update the table column such that country code doesnt exist. 19083452345 14084456789 12023458900 18163456789 I tried to use LPAD, LTRIM but couldnt succeed.
1 2 3
99
100