I need to extract and store the File Path and Filename.EXT from a string into 2 variables.example: \\Server\folder\folder\filename.extI want to end up with:Variable1 = "\\Server\folder\folder\"Variable2 = filename.extIs regex the best way to accompl...
I am creating CSV files (technically TAB delimited) using Compose CSV. I am using a List for the source.I have the option to Force Quotes Set to NO, yet for any fields where I am not supplying a value (as they are not required), double quotes are bei...
Is there a way to specify multiple filename matching patterns for the ON-PREM agent List Files in Folder function?Example:="ARP_CPRF_" + today.strftime("%Y%m%d") + "*.TXT"OR="Process*.TXT"
I am using the On-Prem Agent functionality. When set up, this OPA requires that I specify a Base Folder.Is this Base Folder Path value available for use (eg as a datapill) in a Formula??
In a recipe, there is an error that is being returned in a datapill from an API call.I want to extract just the error "text".Here is a snippet of the string that is being returned:,\"ErrorMessage\":\"Item KL65512 is not valid\",I want to end up with:...
I don’t understand the logic behind it. Firstly, there is the force quote option, which I have turned off. I can understand encapsulating data in quotes when a delimiting character is found in the data — like a comma character when using CSV format, ...
That won't work. Your suggestion just includes all .TXT files in the folder, and could have been stated as simply "*.TXT"I was asking for way to specify multiple search patterns where one filter would include only files with a filename that included ...
Thank you Gary. The snippet that I provided is unique in the string so I avoided posting the entire string.I had gotten close to what you are suggesting and both seem to product the desired outcome..scan(/ErrorMessage\\\"\:\\\"([^\"]+)\\\"/)The API r...
