Sort Tool: Sort string

[RichardAlt]

Hi All,

I'm using sort tool to sort my string.

This is my output when I try to used Sort tool.

TRAD CPF Payment 7/09-11/09/20

TRAD CPF Payment 31/08-04/09/20

TRAD CPF Payment 21/09-25/09/20

TRAD CPF Payment 14/09-18/09/20

I want something like this,

TRAD CPF Payment 31/08-04/09/20

TRAD CPF Payment 7/09-11/09/20

TRAD CPF Payment 14/09-18/09/20

TRAD CPF Payment 21/09-25/09/20

Thanks!

[atcodedog05]

Hi @RichardAlt 

Is there any specific involved in the sort like date or something?

[atcodedog05 · Accepted solution]

Hi @RichardAlt 

I went ahead and considered last 8 digits as date in dd-mm-yy format.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @RichardAlt 

Cheers and happy analyzing 😀👍

[grazitti_sapna]

Hi @RichardAlt , you can try it with regex as well unless/until the date format remains same.

Thanks.