Enfocus Community

Hi Andrew

Yes, you can do all this with scripting. You'll just need the right XPath syntax to identify your target Extrinsic node.

Just as an option I am successfully using a command line tool called xlsx2csv to perform these types of conversions in Switch.

Just Google xlsx2csv.

Hope this helps.

Actually, this is what you need to use in Switch:

[^A-Z-]+[^a-z-]?[a-z-](?=[0-9]{6}).*

Positive look behinds are a no-go as well as negative ones.

I hope this helps.

Hello I've been trying (unsuccessfully) to pipe commands from one command line tool to another using either the Execute command element or (preferably) the process.execute function in the scripting API. Has anyone been successful in doing this within the scripting API? When I try to pipe a command, ...

Hi

This works for me, using a fixed length positive look-behind:

(?<=[A-Z]{7}-[a-z]{5}-).*$

Hi Dwight Thanks for the response and I can report your 2nd option works. I had declared the variableName in the exact same way as your syntax outside the if/else block that does the removal, but setting it inside the conditional block with your syntax sorted it out. Thanks again. William Buckingham

Hello all I'm trying to find the right syntax to remove a directory using the rmdir option in the Utility>Dir class. I've tried every possible syntax variation I can think of and cannot get this option to work. This is the error I receive: Error in line 76 of script : TypeError. 'rmdir' undefined or...

Hi Dwight Thanks for the reply and suggestion. Unfortunately my source array is more complicated and I need to be able to summarize on multiple values. Here is what my array rows look like: ["1040771_300g_DL_4-4_13.pdf","300g","DL","1040773,2] ["1040769_300g_A...

Hello everyone I have a script that does some fairly complicated sorting of production files by pushing segments of file names into an array and sorting on those values to determine the order to SendToData for output. I have a request to be able to provide a production report for a given file proces...

Hi Freddy and thanks for the response. I was actually afraid that was what happened with a SendToXXX function. Can you advise the following then please? Since Switch uses FIFO will each of the files that are sent to the single output receive their unique job numbers in the order specified by the arr...

Hi everyone Can anyone out there advise how I can correctly use the s.sleep function to delay each iteration of a loop that sends a sorted list of files from an array to a single path? I'm not having any luck at all using it inside the loop. Does it perhaps need to be positioned outside the loop? An...

False alarm...I have it working.



Sorry.

Hi Everyone I'm trying to build a script element that will evaluate a directory of jobs, pull key values out of each included file's name and look up two values in a database to determine the file's sort priority. I'll then push that priority to an array for sorting and releasing the jobs into the f...

Dwight I did so and was completely perplexed at what the correct syntax should be based on the manual. Ben at Enfocus suggested the following: Process.execute( ["cmd","/C",ren, theOldName, theNewName] ); However I can't get that to work within the loop function you kindly provide...

Dwight Thanks for that. It has me most of the way there. I note from some earlier posts by you and Ben Schumeth at Enfocus that possibly I could use a Windows ren function using the Process class instead of copying the file. This would actually be ideal as some of these files are quite large and the...