About EasyMorph Tutorials & Examples Web-help

Table-wide Replace Limit

Hi -
I am working on using a table-wide Replace action to replace anywhere that has 2019 with 2020

The data in the column is >300 characters long, I’ve noticed that it will not let me say “Where it’s” entire cell or part of a longer text

Can I assume there is a limit in place for that type of action?

image

Here is a snippet of the data
SELECT count(DISTINCT customerview_totaltrunk_temp.email) AS "1/1/2019" FROM customerview_totaltrunk_temp WHERE ((customerview_totaltrunk_temp.ordercompleted >= '2018-01-01 00:00:00'::timestamp without time zone) AND (customerview_totaltrunk_temp.ordercompleted < '2019-02-01 00:00:00'::timestamp without time zone));

It assumes that 2019 is a number, not text. As with numbers partial replacement is not possible, it offers to replace entire number. There is no limit on text length.

I would suggest using the replace() function if you need to replace a number in a text.

To learn more about EasyMorph visit easymorph.com.