Remove the last X no. of characters in string via Regex

Tips
1

Pinning here to save others some googling… I know I can’t be the only one looking for how to achieve this.

This simple regex expression will remove the last x no. of characters in a string.

.{x}$ where x= the no. of characters you want to remove, including spaces.

(Bubble’s current truncate options doesn’t work for variable string lengths.) My use case is abbreviating formatted Google addresses, as the WHOLE address is not necessary for what I need and clutters my UX. I wanted everything except, the 5-digit zip and “, USA”

Using a dynamic expression, I did a find & replace on my formatted address and checked “Use regex pattern” box.

Screen Shot 2020-10-04 at 9.58.18 PM
Screen Shot 2020-10-04 at 9.58.18 PM813×371 36.7 KB

So,
Google’s formatted address: 6910 Fayetteville Rd, Durham, NC 27713, USA
Displays as: 6910 Fayetteville Rd, Durham, NC

Of course you can build more sophisticated expressions and add different qualifiers, but I just needed the basics here.

Here are my reference, fyi.

The board where I found the expression: regex - How to remove the last 13 (or n) characters of every line using Notepad++ - Stack Overflow

A tester to check & build expressions:

A cheat/reference sheet
https://regexlib.com/CheatSheet.aspx?AspxAutoDetectCookieSupport=1

Happy building :slightly_smiling_face:

14 Likes
2

Love regex!

3

This is exactly what I have been spending the past few hours trying to figure out! Thank you for the example and references!

1 Like
4

awesome. delighted this has helped someone!

5

Thank you @sharifa !
From,
The Future

6

Awesome, couldn’t find the right Regex to save myself!

7

Thank you so much

8

Awesome, after weeks of fooling around with Bubble, this is the first time I’ve logged in, just to make a comment. Had to say THANK YOU for helping me solve a problem I simply couldn’t figure out with “Truncate to” and other operators! Thank you!

9

Wonderful. So glad it saved you some frustration!

10

AGH thank you! I spent way too long trying to find this and here you are! appreciate it.