Hi,
is it possible to use fillnull for fields with a specific pattern? Wildcards are not working, but I want to avoid using fillnull for each and every field.
For example I would like to fillnull all fieldnames that contain "ABC".
Cheers
Heinz
Try this workaround
...| foreach *ABC* [eval "<<FIELD>>"=coalesce('<<FIELD>>',"YourDefaultValueHere") ]
Try this workaround
...| foreach *ABC* [eval "<<FIELD>>"=coalesce('<<FIELD>>',"YourDefaultValueHere") ]
works fine, thanks a lot