Regular expressions

Suggestions for new functionality in NiceLabel. Do you want some feature but can't find it in the NiceLabel software? Post your wish here. Note: This is not a support forum.

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
Julien
Newcomer
Posts: 3
Joined: Sat Feb 28, 2015 5:08 pm

Regular expressions

Post by Julien » Wed Jun 08, 2016 9:20 pm

Hi,

NiceLabel Automation Unleashed.pdf speak about regular expression in NiceLabel Automation but it's seem not be available to detect a data bloc's beginning in Unstructured Data Filter.

Sample
A00001
6D45465123Z
68784E
A10000
9D856989R
A90000
9D856989T
8A6468766G

New blocs start with A char (A only in first position + 5 digits on the same line but i'm not able to specify this), in this sample NL detect 4 blocs - The last one A6468766G is a mistake.

Is it possible searching a string like ^A[0-9]{5}$

Thanks,

J.

User avatar
Saso
NiceLabel
NiceLabel
Posts: 2988
Joined: Mon Sep 04, 2006 8:09 am
Contact:

Re: Regular expressions

Post by Saso » Wed Aug 10, 2016 8:56 am

Hi Julien,

NiceLabel Automation does support regular expressions, but not to define field start / stop position, as you expect. Regular expressions are available a little bit later in the process, when the filer has already extracted the data and you want to manipulate it (such as running search & replace).

This functionality is available in the filter definition itself inside the Field properties, where you can expand "formatting options" and have regular expressions available inside "Search and replace" option. The same option is also available in the action String Manipulation.

It would be useful to have regular expressions available also for the definition of the start / stop position for fields and data areas. Actually, the wish is already logged in the system, I'll make sure the priority is updated.

As a solution to your problem I see a custom script (VBScript/Python) that would parse the data, simplify it and save it to some CSV/XML/database, from where a regular Automation filter can take over.
Saso Fleiser
Senior Technical Product Specialist

Post Reply