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
Like this:
... | rex field=comment mode=sed "s/ .. / /g s/^.. //g s/ ..$//g"
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")
Like this:
... | rex field=comment mode=sed "s/ .. / /g s/^.. //g s/ ..$//g"
thanks! works great!