The filename structure was only an example it can also be: Myfilename_that-look-like_this_ABCD_and-some-other_AB_stuff_12346_HELLOWORLD
I want to check if any of the values in column A could be found anywhere in the filename and return the value in column B from the same row.
Search found 447 matches
- Thu Nov 07, 2024 11:03 am
- Forum: Flows
- Topic: Perform a 'contains' lookup in a spreadsheet?
- Replies: 7
- Views: 151
- Thu Nov 07, 2024 8:47 am
- Forum: Flows
- Topic: Perform a 'contains' lookup in a spreadsheet?
- Replies: 7
- Views: 151
Re: Perform a 'contains' lookup in a spreadsheet?
Hi Thomas, I'm not sure if this is what I'm looking for. I cannot use the filer Column A = *_ABCD_* because _ABCD_ is "unknown". I need to compare the filename (example: Myfile_ABCD_1234.pdf) and see if it contains any of the values in column A and then get a value from column B if I get a...
- Wed Nov 06, 2024 9:41 am
- Forum: Preflighting
- Topic: Extract PDF Annotations to Metadata or Private Data
- Replies: 6
- Views: 10081
- Tue Nov 05, 2024 1:07 pm
- Forum: Flows
- Topic: Perform a 'contains' lookup in a spreadsheet?
- Replies: 7
- Views: 151
Perform a 'contains' lookup in a spreadsheet?
I'm working with a spreadsheet that has two columns, and I need to create a flow to check if "nameProper" contains any of the values from column A. If a match is found, I want to output the corresponding value from column B (as private data). I'm aware of the Row2Variables app, but it only...
- Thu Oct 17, 2024 4:59 pm
- Forum: Flows
- Topic: Best Approach for Error Handling in Enfocus Switch Workflows?
- Replies: 3
- Views: 3048
Re: Best Approach for Error Handling in Enfocus Switch Workflows?
Using the connections I set up 'include these jobs' I use a combination of count and fail element to loop the file from Problem Jobs back to the flow to retry, if it fails again I use the count to push the file to the mail send vs retrying it again since I know it is an actual failure. Hope that he...
- Mon Oct 14, 2024 3:30 pm
- Forum: Griffin
- Topic: Keeping jobs apart
- Replies: 3
- Views: 3381
Re: Keeping jobs apart
I'm also having issues with Griffin Auto on a regular basis. There are too few options in the Griffin Auto app, and as far as I know, it's not possible to achieve the results you're aiming for in the example above. Interestingly, when reviewing the documentation here: https://docs.tilialabs.com/grif...
- Wed Oct 02, 2024 9:19 am
- Forum: Flows
- Topic: Calculate Sum of Values with XML
- Replies: 3
- Views: 2201
Re: Calculate Sum of Values with XML
Roberts' solution is clearly the superior choice between the two options.
- Wed Oct 02, 2024 8:58 am
- Forum: Flows
- Topic: Calculate Sum of Values with XML
- Replies: 3
- Views: 2201
Re: Calculate Sum of Values with XML
I would do this using XSLT (solved with a quick conversation with chatGPT): You can calculate the sum of the <No-Up> values in your XML using XSLT. Below is a simple XSLT stylesheet that will do this: XSLT: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0&...
- Mon Sep 30, 2024 9:24 am
- Forum: Switch
- Topic: Can i moove a newly created job to the problem job folder
- Replies: 2
- Views: 1596
Re: Can i moove a newly created job to the problem job folder
The easiest way to move a job to the problem job folder is to end the flow with an output rule that will never occur.
Example:
Example:
- Fri Sep 20, 2024 1:14 pm
- Forum: Flows
- Topic: Sending files to Sharepoint
- Replies: 3
- Views: 2325
Re: Sending files to Sharepoint
Yes, the flow I'm currently building is set up as follows: 1. Uploading the file to Azure Blob Storage using the Switch Azure Upload app. 2. Sending a JSON payload via the HTTP request app to trigger a Microsoft LogicApp flow. 3. The LogicApp flow downloads the file from Azure Blob and uploads it to...
- Thu Sep 19, 2024 1:11 pm
- Forum: Flows
- Topic: Sending files to Sharepoint
- Replies: 3
- Views: 2325
Sending files to Sharepoint
Have anyone built a flow that send files from Switch to Microsoft Sharepoint?
- Thu Sep 19, 2024 9:20 am
- Forum: Flows
- Topic: Archive hierarchy moving files to wrong folder
- Replies: 3
- Views: 2200
Re: Archive hierarchy moving files to wrong folder
Sorry, I'm not sure I understand your workflow and problem. When you say: I have files coming in, where in the metadata, a link to the location is saved when creating the files by a user. 1. How is this achieved? How are the files "coming in" and in what metadata are the location path stor...
- Tue Sep 17, 2024 3:29 pm
- Forum: Flows
- Topic: Archive hierarchy moving files to wrong folder
- Replies: 3
- Views: 2200
Re: Archive hierarchy moving files to wrong folder
3. I tried changing the Job.Hierachy metadata with string replace to fix the address, but it does nothing there. I tried both, dataset and private data options with (\;tb-fp02\;switch)=T: but nothing changed. In this scenario I would add Job.Hierarchy to a Private Data tag than use the app Private ...
- Fri Sep 13, 2024 9:49 pm
- Forum: Flows
- Topic: Trigger if folder contains files older then 15 minutes
- Replies: 1
- Views: 1692
Re: Trigger if folder contains files older then 15 minutes
Hotfolder Monitor in the free Folder Apps pack will do this for you.
- Tue Sep 10, 2024 1:34 pm
- Forum: Griffin
- Topic: 100 page limit?
- Replies: 6
- Views: 28553
Re: 100 page limit?
Last week I had a meeting with an Enfocus Customer Success representative. We covered a lot of topics, but one of the key discussions was about the absence of a user-driven feature request portal for Enfocus products. She informed me that a feature request portal is in development and should be laun...