Hi, we'd like to update a specific string on a text columns, ie:
before: xxcv adfadf adfadf adfadfadf name : Joe xzczvzdfasdfa a dfadfadfadsfasdfafd
after : xxcv adfadf adfadf adfadfadf name: xxxxxxxxxx xzczvzdfasdfa a dfadfadfadsfasdfafd
before: aaaaaaaaaaaaaaaaa name: Mary bbbbbbbbbbbbbbbbbbb
after: aaaaaaaaaaaaaaaaa name : xxxxxxxxxx bbbbbbbbbbbbbbbbbbb
....
each column is free of type and they all have "name : " in it , any advice would be appreciated
we'd like to do it with "replace, substring..." , but it's flexible column , is it be possible ?