cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
New Member
New Member

Hot Folder Script – Remove Manifest Rows With Duplicate Values

Is there a way to write a script to run before a workflow that will erase rows from a CSV manifest that share specific duplicate values?  The manifest in question needs the duplicate rows for another workflow, but we’d like to use this same data to do something else without having to manually edit the original manifest daily.

The original CSV data would look as follows:

 

"1","05","GM","XXX","0032609","","0620","10KN95","2"

"1","05","GM","XXX","0032609","","0620","50KN95","1"

"1","05","GM","XXX","0032609","","0620","DISPOFM","3"

"2","05","GM","XXX","0032433","","0620","DISPOFM ","1"

 

What I want to do is get rid of any rows that share the same order number (field 1).   So rows 2 and 3 would be deleted and the resulting CSV would end up looking like this:

 

"1","05","GM","XXX","0032609","","0620","10KN95","2"

"2","05","GM","XXX","0032433","","0620","DISPOFM ","1"

 

I’ll be the first to admit that I’m not really familiar with the scripting Core uses, so possibly this question is beyond the scope of what hot folder scripts can do?  

Any input would be appreciated.

Thank you,

RM

Tags (1)
0 Kudos
1 Reply
Highlighted

Re: Hot Folder Script – Remove Manifest Rows With Duplicate Values

Hello,

Maybe you should read this old post first.

Then, as they wrote, as soon as you are able to develop a script (with whatever language you want) and manage to run it "manually" (outside FF Core), then your FF Core Hotfolder will be able to automate. The most important thing, as you will read, is that your script writes it resulting file into the specified output folder.

west-digital.fr

 

0 Kudos