FORUMS: list search recent posts

Search and Replace regex

COW Forums : Square Box CatDV

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
John Heagy
Search and Replace regex
on Mar 25, 2013 at 4:24:17 pm

I'd like to copy the Name field into the Tape field but limit the character length to 6.

Can I use "Name" as a variable in the Replace field and use a regex expression to limit the length? If so How do I enter "Name" as a variable?

This would be easy to do in Bulk edit if it had basic truncate ability.

Thanks
John


Return to posts index

John Heagy
Re: Search and Replace regex
on Mar 25, 2013 at 5:28:31 pm

I could not get Find and Replace to recognize any variables.

I was able to do what I wanted by first using Bulk Edit to copy the entire Name into Tape and then apply the following regex to truncate down to 6 digits:

Search for: ^(......).*

Replace with: 1


Return to posts index

John Heagy
Re: Search and Replace regex
on Mar 25, 2013 at 5:55:31 pm

[John Heagy] "Search for: ^(......).*

Replace with: 1
"


The forum removed the backslash before the 1.

Replace with : (backslash)1


Return to posts index


bryson jones
Re: Search and Replace regex
on Mar 25, 2013 at 7:25:24 pm

Do you want the first 6 characters or the last?

bryson

bryson "at" northshoreautomation.com

northshoreautomation.com


Return to posts index

John Heagy
Re: Search and Replace regex
on Mar 25, 2013 at 8:34:17 pm

Hi Bryson,

First 6


Return to posts index

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
© 2017 CreativeCOW.net All Rights Reserved
[TOP]