topic Re: How do I trim all characters starting from the first digit? in Security

How do I trim all characters starting from the first digit?

sshahmoon — Tue, 27 Nov 2018 02:40:01 GMT

I have a table and I want to trim the values for one field, such that all characters from the first digits onwards are removed
for example:

"dadmin01ldk" will be trimmed to "dadmin"

"rusl90" will be trimmed to "rusl",I have a table with a field.

I want to trim all characters starting at the first digit.

For example, "dadmin02yut" will be trimmed into "dadmin"

FrankVl — Tue, 27 Nov 2018 12:39:12 GMT

Try this, which captures all non-digits from the start of the field (replace 'yourfield' with the actual fieldname from your table):

| rex field=yourfield "^(<yourfield>\D+)"

493669 — Tue, 27 Nov 2018 12:40:39 GMT

Try this regex-

|rex field=<yourfieldname> "^(?<String>[A-Za-z]+)"

It will trim and store result in String field

sshahmoon — Tue, 27 Nov 2018 19:32:06 GMT

could not get it to work

table clienthost | rex field=clienthost "^(\D+)"

sshahmoon — Tue, 27 Nov 2018 19:32:13 GMT

could not get it to work

table clienthost | rex field=clienthost "^(\D+)"

sshahmoon — Tue, 27 Nov 2018 19:33:25 GMT

this works!

thank you!

sandeeprachuri — Tue, 27 Nov 2018 21:32:32 GMT

@sshahmoon, FYI, Above rex works too. However, ? is missing in that regex. Try this,
| rex field=yourfield "^(?<yourfield>\D+)"

Thanks,
Sandeep

FrankVl — Tue, 27 Nov 2018 22:18:27 GMT

Ah, yes, my bad. Thanks for the correction.