Hello all,

Does anyone know if its possible to use regular expressions (or something like) for setting up EntityNameStripPatterns in my project?

At the moment I have this:

{tbl_,SN_ECOMMERCE,SN_SHARED,SN_FILEMANAGER, .......}{}

I'd like to be able to do this:

{tbl,SN[A-Z0-9]+_}{}

Thanks,

I believe this is not possible for the moment, you can only strip prefix and suffix as it is, but no regular expression allowed.

siegemos wrote:

Hello all,

Does anyone know if its possible to use regular expressions (or something like) for setting up EntityNameStripPatterns in my project?

At the moment I have this:

{tbl_,SN_ECOMMERCE,SN_SHARED,SN_FILEMANAGER, .......}{}

I'd like to be able to do this:

{tbl,SN[A-Z0-9]+_}{}

Thanks,

If you are using v2.5, have a look at Project, Properties then click the Abbreviations tab. You can set up two abbrevations, one for "tbl" and one for "SN" and set their Full Word to "".

Cheers Simon

Simon,

unfortunately that doesn't solve my problem, it works great for tbl_ table but the tables prefixed with SN_ are also subprefixed with their module name.

SN_ECOMMERCE SN_PORTAL etc..

So I would still have to add an abbreviation for each of these.

To clarify: I need SN_ECOMMERCE_Cart to become 'Cart' rather than 'ECOMMERCE_Cart' Shame the Pattern can't be done yet. Fingers crossed it will be in there for a future release.

Cheers.

I don't know how many prefixes there are, but you could write them all out, specify them in a file and import them.

siegemos wrote:

Simon,

unfortunately that doesn't solve my problem, it works great for tbl_ table but the tables prefixed with SN_ are also subprefixed with their module name.

SN_ECOMMERCE SN_PORTAL etc..

So I would still have to add an abbreviation for each of these.

To clarify: I need SN_ECOMMERCE_Cart to become 'Cart' rather than 'ECOMMERCE_Cart' Shame the Pattern can't be done yet. Fingers crossed it will be in there for a future release.

Cheers.

Can't you just add more abbreviations? so "SN" = "" and "ECOMMERCE = "" and "PORTAL_" = ""

Cheers Simon

If you are going to specify these patterns in the Abbreviations, why don't you just specify them all in the strip pattern: {tbl_,SN_ECOMMERCE,SN_SHARED,SN_FILEMANAGER, .......}{}