marwest98
11th June 2008, 15:53
Can someone explain what the MASK field on session TFFST1121s000 is for?
I have a user that needs to do a summary on some P&L Drop ship customers, and she needs to not pick up one of the customers. For example, if she needs P&L customers 80 to 89, but needs to skip 83 how would she do this? Would the mask field help? I cannot find what it is for. The people who were here before just told her never to use the field, but they never could explain why. I'd like to know what it is for so that I can explain it to her.

I'd also like to know how she can do a summary of P&L, but skip one customer.

Thanks.

marwest98
11th June 2008, 17:03
Additional information for second question:
She need to set up an fst for a group of branches. As an example, she want to pick up a group of 10 consecutive branches but she doesn’t want to include the seventh branch in that group of ten. And she is wondering if this “Mask “ field can be used to exclude that seventh branch.

marwest98
11th June 2008, 20:22
Here's what I have figured out so far.

Once you have entered specifig ranges of dimensions, you can also use the mask for smaller selections.

For example:
$ - the number to be selected should end in the character preceding the $
^ - the selection must start at the first character
* - the preceding character must occur one or more times
[5-9] - the character to be selected must be between 5 and 9
[579] - the value of the character to be selected must be 5,7,or 9
... - the dots indicate the number of characters

This works fine if you have dimensions like this and you only want to select a few:
899011
899027
899031
899042
899135
899168
899281
899292
899315

to select 899031 and 899281, I would type ^....[3-8]1$
to select 899135 and 899315 I would type ^...[13]*5$

However, my dimensions are
PRE039
pre040
pre041
pre042
pre043
pre044
pre045
pre046
pre047
pre048
pre049
pre050
pre051
pre059
pre068
pre073
pre074
pre075
pre076
pre077
pre081
pre082
pre083

so, I need to skip pre051. I can't figure out how to get all the others, but skip pre051.

Help!!!!!