space in field value

[ambemou]

Hello all,

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 :

field value

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.

[gpareesi11]

Hi,
I don't know the exact use case, but you can try this:
| rename "Nom du compte" AS username

Thank

[linu1988]

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.