Hi,
I have a Logic Apps process built which processes files uploaded onto our SFTP server.
The file naming convention is <DIGITS>_<FILENAME>. I would like to somehow extract the digits from the filename to pass as a parameter into a stored procedure.
What would be the best method of extracting the digits please? Essentially I need all numbers at the start of the file name prior to the first "_" (underscore).
Any help would be very much appreciated.
Thanks!
