This is my first post here! _I am new and I am learning
Hi Experts,
I have data like below coming into a csv file.
ref1 | toref1 |
16YcK36 | bc46 |
20Sdj60 | fg64 |
13Nbc46 | dj60 |
15Nfg64 | nf32 |
13Tnf32 | cK36 |
and my end result, I would like the table to be like below: (Edited: My search should be sorted (column no 2) - should match the last 4 with column 1). Please refer to below table. Thanks in Advance.
ref1_tobe | toref1_tobe |
16YcK36 | cK36 |
20Sdj60 | dj60 |
13Nbc46 | bc46 |
15Nfg64 | fg64 |
13Tnf32 | nf32 |
I am not sure what you are asking for - is it just the last 4 characters of the ref field?
| eval toref=substr(ref1_tobe,-4,4)
Thank for you reply but It needs to be re-arrange and sort based on the left column, like table below:
IF 16YcK36 this is in the first row, then cK36 must on that row as well, because the data at 2nd column it goes in random and not sorted according to the last 3 string of column 1.
ref1_tobe | toref1_tobe |
16YcK36 | cK36 |
20Sdj60 | dj60 |
13Nbc46 | bc46 |
15Nfg64 | fg64 |
13Tnf32 | nf32 |
Your toref1_tobe column is not sorted - is this just a typo or is there some logic behind this sort order?
If you want to sort by a field use something like this
| sort 0 toref1_tobe