Use Alpha characters instead of expanding field

Question

Use Alpha characters instead of expanding field

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

below86 SSChampion Points: 11579 More actions · Answer 1

We don't want to expand to a 4,4,4 because we would need to update all of the places that use the field to account for the larger size and the values being in different locations within the field.

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 2

Yep... there's the "can thing" and understood.

Since values from 000 thru 999 have already been distributed, we can't just use the simplicity of base 36 so I guess I'd do what you suggested near the beginning. It won't necessarily require a lookup table but it will require two separate calculations if the source columns are integer based.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

below86 SSChampion Points: 11579 More actions · Answer 3

We haven't had much added to our back log of work for several months now. So splitting these out into three columns may be something we can tackle in late 2023 or early 2024. But I'm not holding my breath. At least we have it set up as a work around to use the alpha characters for now.

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 4

Understood. That's why I suggested that your first take on the subject is probably your best take.

To prevent any overlapping of old vs new, leave everything you currently have alone. Not map table required.

If you do it right, you won't need a map table for anything else, either. Just consider anything from 999 or less to be that literal. Any greater than that would start off with the number 1000 mathematically translated to "AAA". Then do the base 26 or 36 math from there on up.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

below86 SSChampion Points: 11579 More actions · Answer 5

We did go with a conversion table, this way we could eliminate some bad words or abbreviations. I don't think we had anything that would go out with that info on it, but didn't want to take a chance.

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 6

below86 wrote:

We did go with a conversion table, this way we could eliminate some bad words or abbreviations. I don't think we had anything that would go out with that info on it, but didn't want to take a chance.

Aye. Thanks for the feedback.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)