0 - 6 of 6 tags for trim

hello everyone.

 

i have an INSERT query with a subquery like this one:

 

SELECT 1

 

            FROM SD_CRM.D_INDIV_PREF DIP

 

            WHERE DIP.SITE = FPL.SITE

 

                AND  TRIM(DIP.ID_CLIENT) = TRIM(FPL.ID_CLIENT)

 

Hello,
This question is a spinoff of the following thread:
http://forums.teradata.com/forum/database/concatenate-value-of-multiple-rows-into-one-single-row-1#comment-133576

Hi All,

 

I have used TRIM ( BOTH FROM string_name) command to remove extra character / space coming in export file but it is not working. could you please help to resolve this issue ?

 

.set format on;

.set width 1000;

.set pagelength 100000;

.set heading '';

.set footing '';

I have a table with a column of alpha-numeric data the currently has multiple (periods) "." and spaces in the string.

I need to remove them for data compare in another DBMS.

I have searched not only through this forum but others as well and can not seem to find the solution.

I want to remove leading and trailing tabs in a column... I tried trim function and its not working... is there any other means we can remove the leading or trailing tabs...

Hello,

My table tbl has a column col which has the below definition:-
COL VARCHAR(250) CHARACTER SET UNICODE NOT CASESPECIFIC TITLE 'COL'

I am trying to trim spaces on the data in the this col. I used TRIM and what I see in the result is that it trims leading spaces but not the trailing spaces. I have tried various combinations in the query below:-

SEL COL,CHARACTER_LENGTH(COL),COL||'-',
TRIM(COL) a,CHARACTER_LENGTH(a),A||'-',
TRIM(TRAILING' ' FROM COL) B,charACTER_length(B),B||'-',
TRIM(TRAILING' ' FROM CAST(COL AS VARCHAR(2000))) C,CHARACTER_length(C),C||'-',