Remove words from a String

[sebafdez]

Hi guys!

I need to remove words from 2 char in a string, I have a field like:

comment="La pagina web es muy mala demasiado lenta"

and I want it to be like:

new_comment="pagina web muy mala demasiado lenta"

where words of 2 char doesn't exist anymore, any idea how to implement this in SPL?

regards

[somesoni2]

Give this a try (Run anywhere sample search, replace line 1 with your search)

| gentimes start=-1 | eval comment="La pagina web es muy mala demasiado lenta 1 12 123 44" | table comment 
| eval new_comment=replace(comment,"(^|\s)(\w\w)(\s|$)","\1")

[woodcock · Accepted solution]

Like this:

...  | rex field=comment mode=sed "s/ .. / /g s/^.. //g s/ ..$//g"

[sebafdez]

thanks! works great!