Question : In the above screen shot, the Description column has many special characters. We want before | number update […]
Tag: string-manipulation
Wordcount in a field (all and unique) – is there a more elegant/optimal way?
Question : Answering this question, Given this table (constructed from the question): CREATE TABLE wordcount (id SERIAL NOT NULL PRIMARY […]
Concatenate a string value from table A to a text field in table B, in a scalable way
Question : On a daily basis, I am adding values from the following table (table1): Id Name Value 1 ‘Name […]
Find rows with similar string values
Question : I have a Microsoft SQL Server 2012 database table with around 7 million crowd-sourced records, primarily containing a […]
Efficient way to see what pattern matches a single word
Question : I’m creating a function to find out what search pattern would best fit a single string. The string […]
PostgreSQL: Function to reformat a string
Question : Suppose I have a string such as: abcdefghi and I would like to reformat it as: abc def […]
Locate a specific word in a database
Question : Goal Locate a specific word among tables in a database and display the name of the table and […]
Does a Levenshtein distance involve some computation for each single row?
Question : Let’s say I have, in a SQL DB, a table with 2 columns: id integer, description text and […]
How to remove specials characters, but replace spaces?
Question : I have a string with spaces & special characters: ABC%$! DEF*& GHI I want to remove all the […]
Wordcount in a field (all and unique) – is there a more elegant/optimal way?
Question : Answering this question, Given this table (constructed from the question): CREATE TABLE wordcount (id SERIAL NOT NULL PRIMARY […]