Sorting a CSV before processing?

Post Reply
w.bromley
Member
Posts: 37
Joined: Tue Sep 07, 2021 12:09 pm

Sorting a CSV before processing?

Post 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!!
User avatar
magnussandstrom
Advanced member
Posts: 510
Joined: Thu Jul 30, 2020 6:34 pm
Location: Sweden
Contact:

Re: Sorting a CSV before processing?

Post 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
Last edited by magnussandstrom on Wed Nov 13, 2024 12:26 pm, edited 1 time in total.
User avatar
JimmyHartington
Advanced member
Posts: 456
Joined: Tue Mar 22, 2011 7:38 am

Re: Sorting a CSV before processing?

Post by JimmyHartington »

Magnus beat me to it.
I second the suggestion for using Easy Data Transform.
w.bromley
Member
Posts: 37
Joined: Tue Sep 07, 2021 12:09 pm

Re: Sorting a CSV before processing?

Post by w.bromley »

This looks absolutely perfect - I will have a play!

Thank you both!!
User avatar
tdeschampsBluewest
Member
Posts: 128
Joined: Tue Jun 01, 2021 11:57 am

Re: Sorting a CSV before processing?

Post 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...)
Do you like the Enfocus Apps developed by Bluewest?
Feel free to leave a comment on the Appstore!
w.bromley
Member
Posts: 37
Joined: Tue Sep 07, 2021 12:09 pm

Re: Sorting a CSV before processing?

Post by w.bromley »

What do you mean scam part? The weird geometry dash bit at the end?
User avatar
tdeschampsBluewest
Member
Posts: 128
Joined: Tue Jun 01, 2021 11:57 am

Re: Sorting a CSV before processing?

Post 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
Do you like the Enfocus Apps developed by Bluewest?
Feel free to leave a comment on the Appstore!
w.bromley
Member
Posts: 37
Joined: Tue Sep 07, 2021 12:09 pm

Re: Sorting a CSV before processing?

Post by w.bromley »

Huh yeah you're right - what a weirdly specific place to be adding spam links to things!!
Post Reply