Is it possible to change a word using regexp_replace() function?

Question

Is it possible to change the State_Name to California using regexp_replace()?

select  REGEXP_replace("Name,Door_No,Street_Name,Area_Name,State_Name,12345", r"","California") AS example

Mikhail Berlyant · Accepted Answer · 2018-03-28 20:56:08Z

2

One of the many options -

#standardSQL
SELECT REGEXP_REPLACE(
  "Name,Door_No,Street_Name,Area_Name,State_Name,12345", 
  r"([^,]*,)([^,]*,)([^,]*,)([^,]*,)([^,]*)(,[^,]*)", 
  r"\1\2\3\4California\6"
) AS example

returns

Row example  
1   Name,Door_No,Street_Name,Area_Name,California,12345

answered Mar 28, 2018 at 20:56

Mikhail Berlyant

174k10 gold badges173 silver badges251 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to change a word using regexp_replace() function?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related