Convert text strings to a code or number
I also think you need to be a bit more explicit about the nature of the
"Entity" and its "Intercompany". Your example just shows two 4
character names, but is this representative of what you will have in
reality? Could you, for example, have "ApplesPears" and "PearsApples",
or "PineappleGrapes" and "GrapesPineapple" - how would you know where
to split the combined strings?
Pete
|