Keeping N characters in a text string

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
carl34
Posts: 1
Joined: Thu Mar 09, 2017 3:56 am

Keeping N characters in a text string

Post by carl34 »

Hello
I am on a trial of your wonderful software. How do I replace a text string with the 3 first characters of the same text string (i.e.just keep first 3 characters) ? The text string can be of any length and will start with "$" and end with ".csv".
Thank you!
Carl
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Keeping N characters in a text string

Post by DataMystic Support »

Use an EasyPattern:

Find

Code: Select all

[ capture( 3 chars) as 'first', longest 1+ not cr or lf ]
Replace with

Code: Select all

@first@my new string
Post Reply