Replacing Whole Words Only using @replace

Gerard Usher

Wed, 03/29/2023 - 13:04

Forums

General discussion

Hi All!

I'm trying to use @ replace to clean up a big Vendor Liost by replacing some common Company Names with "" (essentially removing the bits I don't want).

When I use Add Virtual Charachter and the parameters below, it removes parts of words, as well as whole words. How can I tell IDEA to replace Whole Words Only?

@replace(@replace(@replace(@replace(SUP_NAME, "CO", "" ),"AS", "" ),"AGENCY" , "" ),"AGENCIES" , "" )

In this example above "DALLAS COUNTY AUDITOR" becomes "DALL UNTY AUDITOR"

Use spaces or regular

scotchy33 Wed, 03/29/2023 - 17:45

Use spaces or regular expression (@RegExpr).

@replace(@replace(@replace(@replace(SUP_NAME, " CO ", "" )," AS ", "" )," AGENCY" , "" )," AGENCIES" , "" )

Thanks for the advice scotchy

Gerard Usher Wed, 03/29/2023 - 17:59

Thanks for the advice scotchy 33. How would that work in my example?

I would go in equation editor

scotchy33 Thu, 03/30/2023 - 11:55

I would go in equation editor and read about @RegExpr and play with it a bit.

Replacing Whole Words Only using @replace

Forums

Use spaces or regular

Thanks for the advice scotchy

I would go in equation editor

Share This Page