Stack Overflow
Stack Overflow

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
2 answers

How to trim String directory in java

I am trying to trim my directory which is in string format in java . I only want images/filename and want to remove directory before images.
user12731294
  • 41
  • 4
0
votes
6 answers

SQL Trim on a file name

I am trying to trim a long file name and just want to get the last characters of that file name which is after the last forward slash (\) and I also want to eliminate the .xlsx at the end of the file name as…
Minhal
  • 85
  • 2
  • 17
0
votes
1 answer

SQLPLUS - ORACLE 12 - Trim extra columns white space

I've a problem with a sqlplus spool (oracle 12c/18c). I want trim extra white space in columns. This is the expected result 01JHON BROWN 30RED 02MARIO ROSSI 25WHITE this is my result 01 JHON BROWN 30 RED 02 MARIO…
Luca Archetti
  • 1
  • 1
  • 3
0
votes
1 answer

Clear both the left 14 characters and "x" right, after a specific character

i have a mysql table with records like: ANGRY BIRDS 2
Thurop Van Orman, John Rice (USA, Finland)
5/9/2019 – Spentzos Film THE FAVORITE
Giorgos Lanthimos (USA, UK, Irland)
5/9/2019 - Feelgood…
Kostas Konstantinidis
  • 27
  • 8
0
votes
0 answers

How to trim String values in 2d array using Java stream API and collect back to 2d array?

Any idea how to perform a trim operation on a 2d array of strings e.g. 3x3 using Java stream API and collect one back to same dimension 3x3 array? The point is to avoid using explicit for loops. The current solution would be simply to do a for loop…
Danil Tk
  • 29
  • 1
  • 6
0
votes
1 answer

Trim Function doesn't remove any spaces from any side

I try to trim spaces in Calc using a macro. The Trim function doesn't seem to work I tried using Trim, LTrim, RTrim but same result. Anybody have an idea of where is wrong? oCSL is "Arang and the Magistrate" oCSR and z should also be like oCSL after…
Michael Duc
  • 11
  • 2
0
votes
2 answers

Freeze the text of the TextView + android

I am using textview for adding text in my application, i want the text should singleLine that i did, now the problem is that the word got cutted off i.e suppose in my textview the text would Hello, how are you? What going on? if the text is long and…
Mohammed Azharuddin Shaikh
  • 41,633
  • 14
  • 96
  • 115
0
votes
2 answers

Trim ending white space of lines in .txt file

I am trying to remove the last space of a file.txt which contains many rows. I just need to remove "only the last space" after the third column/each line. My file looks like this: 3 180 120 3 123 145 6 234 0 4 122 12 I have been…
Nella
  • 37
  • 2
0
votes
2 answers

Remove Trailing Text (Multiple Characters)

In VB.NET, I want to remove an entire string from the end of my variable and not individual characters. What is the best way to do this? For example, my string text is as follows: Jack left with 3.00 in his pocket but returned with only 2.00 I want…
Acavier
  • 79
  • 7
0
votes
2 answers

Oracle Select query doesnt return any results when using trim on char(2) column and database field has only spaces

Oracle Select query is not returning any results when using trim on char(2) column. The database field has only spaces. However, when the field has a space and a character, I get the correct results. e.g. Action_code char(2) val = " 8" Select *…
Amit Joshi
  • 1
  • 1
0
votes
1 answer

how to add vallue using jquery

$("#totalinvoicevalue").text($.trim($('#total_product_gst').html()) + totalcharge.toFixed(2)); $.trim($('#total_product_gst').html()) = 1050.00 totalchage = 100 I get result 1050.00100 I expect 1150.00 please help how to deal with it in jquery …
rupali
  • 3
  • 4
0
votes
1 answer

GCC : Segmentation Fault from Trim function

I got a gcc "Segmentation Fault" error with this script : http://paste2.org/p/1397204, why ? I tested this code with Visual C++ compiler and I don't get any error...
bernedef
  • 699
  • 2
  • 12
  • 22
0
votes
1 answer

How do you turn off the postgresql trim function? I want to KEEP whitespace in db

I want to save text KEEPING whitespace, but postgresql automatically deletes whitespace with a built in trim function. I want to turn the trim function off. When I save text, I want to KEEP whitespace. My table looks like this: create table…
Page COW
  • 515
  • 13
  • 31
0
votes
3 answers

Remove Characters from Google Sheets up to @ sign

I have a column of E-mail addresses in a Google Sheet and want to remove all of the domain names and '@' symbol and copy this to a new column. For example: Column-A test@test.com testb@gmail.com testc@yahoo.com Copied and removing the domains…
Jeeves
  • 424
  • 1
  • 7
  • 25
0
votes
2 answers

Remove the first leading zero

I'm trying to delete only the first zero from the values of a field which now are: 00,01,02,03 etc and I'm using this function: string_trim['0', begin]. The problem with it is that it works for all the values but not for 00, since it removes…
cautis anca
  • 5
  • 2
1 2 3
…
99 100