Hi all, need help create a search column REGEX to ...
# suitescriptd
darrenhillconsulting
05/03/2023, 6:01 PMHi all, need help create a search column REGEX to capture everything after the last occurrence of " - " (spaceHYPHENspace)
darrenhillconsulting
05/03/2023, 6:01 PMSo, for
0190 1st Ave - Napa - Sonoma, CA - The PalmThe Palmdarrenhillconsulting
05/03/2023, 6:02 PMI'm close but just can't get it quite right
darrenhillconsulting
05/03/2023, 6:02 PM Copy code
([^\s-\s]*)$Palmdarrenhillconsulting
05/03/2023, 6:04 PM Copy code
([^-]*)$The Palmn
Nathan L
05/03/2023, 6:04 PM- (.+)$
Nathan L
05/03/2023, 6:04 PMmaybe. i wrote that without testing
d
darrenhillconsulting
05/03/2023, 6:05 PMNo, not quite @Nathan L
n
Nathan L
05/03/2023, 6:06 PM- ([^-]+)$
Second Try
d
darrenhillconsulting
05/03/2023, 6:07 PMCloser, that match 'includes' that spaceHYPHEN
n
Nathan L
05/03/2023, 6:09 PMlast try then ill leave you alone lol
Copy code
(?<!-)- (?<= )([^-\n]+)$d
darrenhillconsulting
05/03/2023, 6:10 PMNo sir, thanks though
sadblob 1
a
Anthony OConnor
05/03/2023, 7:31 PMdoes it NEED to be a regex?
r
Richard Tanner
05/03/2023, 7:49 PMsomething like this maybe?
Copy code
(?!.*-)[^\s].*$🎉 1
m
Michael Pope
05/03/2023, 8:06 PM@darrenhillconsulting You can use this (it uses .replace())
'0190 1st Ave - Napa - Sonoma, CA - The Palm'.replace(/ \- /g,'');battk
05/03/2023, 8:20 PMit also has nice non regular expression based answers
d
darrenhillconsulting
05/04/2023, 1:23 PMThanks everyone. I went with
(?<= - )[^-]+$REGEXP_SUBSTR({companyname}, '(?<= - )[^-]+$', 1, 1, NULL, 1)👍 1
9 Views