Remove every string before certain words (String Manipulation) using RegexReplace
Hello
I wanna ask how can we string manipulate these column into returning value as detailed below
Value :
C:\Users\ASUS\OneDrive - Bina Nusantara\Desktop\Input Join SPK DO PSPK\2. Data DO Closing\1. Laporan Penjualan Closing Januari 2024.xlsx
C:\Users\ASUS\OneDrive - Bina Nusantara\Desktop\Input Join SPK DO PSPK\2. Data DO Closing\1. Laporan Penjualan Closing Januari 2024.xlsx
C:\Users\ASUS\OneDrive - Bina Nusantara\Desktop\Input Join SPK DO PSPK\2. Data DO Closing\1. Laporan Penjualan Closing Januari 2024.xlsx
Aimed :
Laporan Penjualan Closing Januari 2024.xlsx
Laporan Penjualan Closing Januari 2024.xlsx
Laporan Penjualan Closing Januari 2024.xlsx
I’m using RegexReplace inside the String Manipulation nodes
So I wanted to remove every value before the word “Laporan”