I need to know how i can erase space in field value. In security audit of windows system the username in french is like this :
Nom du compte : ank02
space in the name fo the field and name in the value. i can make graph with this value but table with a same value the name ank02 not appear.
Thanks for help.
Is the field has the value "Nom du compte :"? If not you have to manually extract and make a field, then u can use it for tables/graphs.
I don't know the exact use case, but you can try this:
| rename "Nom du compte" AS username