-
Search and Replace regex
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 -
4 Replies
-
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
-
[John Heagy] “Search for: ^(……).*
Replace with: 1
“The forum removed the backslash before the 1.
Replace with : (backslash)1
-
Do you want the first 6 characters or the last?
bryson
bryson “at” northshoreautomation.com
northshoreautomation.com
-
Hi Bryson,
First 6
Reply to this Discussion! Login or Sign Up