Start a new topic

Reg Exp - keep only first 20 characters

Is this possible? I need to import something that is too long for the length of the DB field, so I'd like to import only the first 20 characters of that...


Is this possible with reg expressions? I tried few different ones, but none worked :-(


Thank you!


Grazi

1 Comment

Hi Grazi,


Try this:


Replacement Value: $1

Values to match on: ^(.{20}).*?$


Angela

Login to post a comment