Replacing multiple values of a field with single value with rex sed

[viswatejabolla]

Hi All,

I have field called stepName which will have below three values.

TextResource.getFirstLine

TextResource.getSecondLine

TextResource.getLastLine

How can write a rex with mode=sed to replace only the words First,Second and Last from the stepName field to "Which", so that my output will have only one stepName field value as "TextResource.getWhichLine".

[richgalloway]

This should do it.

| rex field=stepName mode=sed "s/(First|Second|Last)/Which/"

[viswatejabolla]

Hi Rich,

Thanks for responding. Those are not the only three which I have. There are some other stepNames as well which have same starting string and ending string. Adding all of those words to the search string will make it ugly.

Anything can be done like "startswith" and "endwith", or by a regex which can do this without giving all the words.

[richgalloway]

| rex field=data mode=sed "s/(TextResource\.get).*(Line)/\1Which\2/"