Page 1 of 1

Sorting a CSV before processing?

Posted: Wed Nov 13, 2024 12:06 pm
by w.bromley
Hi Guys!

Just wondering if anyone has come up with a way (or could think of a way) to reorder a CSV based on something super simple such as column X descending.

Basically, the data is "grouped" in such a way that would make it far easier for our fulfillment guys if it was in order (think data tagged in column X with a gets pack a, b gets pack b, etc. but the data is sorted by column Y by default).

Any help much appreciated - thanks in advance!!

Re: Sorting a CSV before processing?

Posted: Wed Nov 13, 2024 12:23 pm
by magnussandstrom
Yes, get Easy Data Transform: https://www.easydatatransform.com/

And there is a new Switch app that makes it super simple to run the "transforms" in a Switch flow: https://www.enfocus.com/en/appstore/pro ... sform-beta

Re: Sorting a CSV before processing?

Posted: Wed Nov 13, 2024 12:24 pm
by JimmyHartington
Magnus beat me to it.
I second the suggestion for using Easy Data Transform.

Re: Sorting a CSV before processing?

Posted: Wed Nov 13, 2024 1:04 pm
by w.bromley
This looks absolutely perfect - I will have a play!

Thank you both!!

Re: Sorting a CSV before processing?

Posted: Wed Nov 20, 2024 9:19 am
by tdeschampsBluewest
dramaticinsecure wrote: Wed Nov 20, 2024 8:18 am
magnussandstrom wrote: Wed Nov 13, 2024 12:23 pm Yes, get Easy Data Transform: https://www.easydatatransform.com/

And there is a new Switch app that makes it super simple to run the "transforms" in a Switch flow: https://www.enfocus.com/en/appstore/pro ... sform-beta
It uses a visual workflow approach, allowing users to drag and drop transformations for CSV, Excel, and text files without coding.
Oh the scam... Bot are getting creative this days. (i removed the scam part from the double link, to avoid people clicking it...)

Re: Sorting a CSV before processing?

Posted: Wed Nov 20, 2024 9:49 am
by w.bromley
What do you mean scam part? The weird geometry dash bit at the end?

Re: Sorting a CSV before processing?

Posted: Wed Nov 20, 2024 10:35 am
by tdeschampsBluewest
w.bromley wrote: Wed Nov 20, 2024 9:49 am What do you mean scam part? The weird geometry dash bit at the end?
Yes, i did not even clicked on it, but when you see a new user with only 1 post, quoting and adding something to a link... well...

It's either a scam, or something to boost click/view/cross references...

Same link is also in the bio of the last user posting here :
viewtopic.php?t=4542

Re: Sorting a CSV before processing?

Posted: Wed Nov 20, 2024 10:48 am
by w.bromley
Huh yeah you're right - what a weirdly specific place to be adding spam links to things!!