How do I sort this single field properly? I already tried | sort - field_name. I tried creating a rex and then sorting that field, but no changes.
field_name
value_1_asdfasdfasdf
value_10_asdfasdfasdf
Value_11_asdfasdfasdf
Value_12_asdfasdfasdf
value_2_asdfasdfasdf
value_3_asdfasdfasdf
value_4_asdfasdfasdf
value_5_asdfasdfasdf
value_6_asdfasdfasdf
value_7_asdfasdfasdf
value_8_asdfasdfasdf
value_9_asdfasdfasdf
I want the results as follows
value_1_asdfasdfasdf
value_2_asdfasdfasdf
value_3_asdfasdfasdf
value_4_asdfasdfasdf
value_5_asdfasdfasdf
value_6_asdfasdfasdf
value_7_asdfasdfasdf
value_8_asdfasdfasdf
value_9_asdfasdfasdf
value_10_asdfasdfasdf
value_11_asdfasdfasdf
value_12_asdfasdfasdf
Try to extract all the digits from the data and then sort it.
....|rex field="field_name" "_(?P<dummy>[\d]+)_"|table field_name,dummy|sort +dummy
OR
....|eval dummy=replace(field_name,"\D","")|table fild_name,dummy|sort dummy
Thanks
Try to extract all the digits from the data and then sort it.
....|rex field="field_name" "_(?P<dummy>[\d]+)_"|table field_name,dummy|sort +dummy
OR
....|eval dummy=replace(field_name,"\D","")|table fild_name,dummy|sort dummy
Thanks
Oh, extract just the numbers.... okay I will test this soon and get back. Probably will work.