regex

[Hamder83]

Hi 

I have this filename:
c:\dennis\ay\ABOUT YOU GmbH_BALTICS2022_2021-02-15_20210216-1013_FAM_(081)_CODCorrect.xlsm|||`INPUT PARCELS$B5:N105`

how do I delete from ||| and the rest of the filename?

[Jean-Balteryx · Accepted solution]

Hi @Hamder83 ,

You can do it using Regex tool.

\|\|\|.*

Workflow attached !

[atcodedog05]

Hi @Hamder83 

I was confused whether you wanted to keep filename or sheetname so i have just split it keep whichever you want😅

Hope this helps : )

[Hamder83]

Your a genius @Jean-Balteryx 

Thank you very much 🙂 

[Jean-Balteryx]

You are welcome @Hamder83 ! 🙂

[jybq]

Thank you. 

just found it can also use just below, since escape from the first | and .* and replace the second and third | and the remaining.

\|.*