Solved

Regular Expression - Extract text between 2 characters in document filename

  • 10 February 2022
  • 2 replies
  • 413 views

Badge +4

I'm trying to extract part of a filename, everything after " - " and before the " .pdf ":
3114062-123456789.pdf

I'm using this expression:

(?<=-).*(?=.pdf)

It works, except that it always includes a " ; " at the end when I insert it into SharePoint.

How do I get rid of the  " ; "

 

icon

Best answer by mlauer 11 February 2022, 10:20

View original

2 replies

Badge +9

With extract, the result is written to a collection. You have connected this collection variable to a SharePoint column. This is the reason for the semicolon at the end. Either you assign the 1st element of the collection to a single line text variable and store it in the list or you use the operation replace text instead of extract. Here the result is assigned to a single line text variable, which can be stored in the list. You can use ^[^-]*-(.*).pdf$ as pattern and $1 as replacement text.

Badge +4
Awesome, using the operation replace text and your pattern worked! Thank you so much.

Reply