python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - replace

Remove certain characters in a column Snowflake

I am having data in a column like 'EARTH PLANET-ABC', 'MARS PLANET - ABC', 'JUPITER -ABC', 'VENUS- ABC' etc. I need to return the values 'EARTH PLANET', 'MARS', 'JUPITER', VENUS etc whenver the column...
test-img

Jude92

sql

replace

snowflake-cloud-data-platform

Votes: 0

Answers: 2

Latest Answer

SELECT SPLIT_PART(column,'-',1)::varchar This splits your field by the hyphen and then gives you the first piece of it. Seems like that's what you're looking for. You might also need to trim the re...
test-img

Mike Walton

Plop doesnt generate my component because replace is undefined

I struggle with this problem and I don't know why the cmd say that replace is undefined. I researched a bit but couldn't find any reason why the script should fail. I console.log the whole flow of the...
test-img

Knome1936

replace

cmd

generator

yarnpkg

plop

Votes: 0

Answers: 1

Latest Answer

To achieve the processing you expect, use {{pascalCase componentName}} instead of {{camelCase name}} write the value of the name option directly. I'm sorry for my poor English.
test-img

hogehoge

how to convert unicode to german umlauts with sql query SQL Server

I have a SQL table that stores values entered by the user. After users entered German umlauts, it was saved in SQL as follows: müssen, Üben and much more. Now I need a SQL Query that...
test-img

tristan

sql

sql-server

replace

unicode

diacritics

Votes: 0

Answers: 2

Latest Answer

I think this could be your solution: UPDATE db.tablename SET fieldname = REPLACE(fieldname, 'ü', 'ü') WHERE fieldname LIKE '%ü%';
test-img

Mickey Pearson

Matcher.replaceAll() removes backslash even when I escape it. Java

I have functionality in my app that should replace some text in json (I have simplified it in the example). Their replacement may contain escaping sequences like \n \b \t etc. which can break the json...
test-img

SorryForAsking

java

string

replace

Votes: 0

Answers: 3

Latest Answer

StringEscapeUtils.escapeJava("\n") allows you to transform the single newline character \n into two characters: \ and n. \ is a special character in pattern replacements though, from https:/...
test-img

sp00m

Posts

Questions

Blogs

Jobs