0 - 11 of 11 tags for string

Hi,
I need to remove all the chars from an alpha numeric string ('AL234ps12;') to get 2342 as the result or
fetch 2342 from the an alpha numeric string ('AL234ps12;').
could anyone give me some idea plz.
 
Thanks & Regards,
Venkatesh Gubba

In our database we have a system-generated ID that is built off of the timestamp. It’s not a date or time format, it’s a string, like (20130405103422), which is essentially the year, month, day, hour, minute and second that the record was created. I want to join it to another field, which is date, but I need to convert it first. How do I do that

Hi to the performance experts among you.
 
We have a pretty large key table, with at least one VARCHAR(30) column storing the real world source key, here SOURCE_KEY_COLUMN1, and one bigint column storing the surrogate key (PI), here EVENT_ID.
 
CREATE MULTISET TABLE KEY_EVENT [...]
     (
      EVENT_ID BIGINT,

Hi All,
I am fairly new to Teradata 14 and want to use the Regular Expressions.
I have a column that has values as below.

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 want to remove periods from the concatenated string. Please help as I tried all options inlcuding Cast, Format etc.
 
My query is
SEL CONCAT(id, rec_num, line_no, dep_no, asp_num, pr_num) as mystr
from table_oemsp
 
I get the output as
mystr
0.0.300.900.0
11.20.123.123.20
etc.
 

Is there a Teradata way of doing the JARO_WINKLER_SIMILARITY Function that Oracle has?
http://docs.oracle.com/cd/E14072_01/appdev.112/e10577/u_match.htm
JARO_WINKLER_SIMILARITY Function

I have created a table with a column that is varchar(5). When I insert a string of 6 characters the string is truncated to 5 characters rather than throwing an exception. Is there a way to force a strict mode so this will result in an error?

Jesse

Hi,

Is there any function to find the number of occurences of a particular substring within a string in teradata?

Eight UDFs that search VARCHAR and CLOB string sources to see if they contain VARCHAR or CLOB string sets. Four of the UDFs are overloaded (named the same) to return the result in the form of VARCHAR or CLOB string while the other four UDFs are overloaded to return an INTEGER index into the string source if a match is found.

This package contains two string-related UDFs. The Edit Distance function returns the minimum number of edit operations required to transform string1 into string2. The N-Gram matching function returns the number of n-gram matches between two strings.