Algorithms: verhoeff, base64, alleged RC4. in VBA (excel)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • freemanthink
    New Member
    • Feb 2021
    • 2

    Algorithms: verhoeff, base64, alleged RC4. in VBA (excel)

    Excuse me, I speak Spanish. I am self-taught in computer science and I ventured to make a payment system for my small shop. the problem is; that for my billing system to work the algorithms are missing: presumed rc4, verhoeff and base64, in VBA language, I don't understand this and I wanted to ask if you had any of this among your algorithms that you could share with me, I am very grateful.

    The algorithms must satisfy the result of the following examples:

    '*******input data
    Authorization: maximum fifteen digits (numbers).
    Invoice: maximum twelve digits (numbers).
    DNI: minimum value = zero (one digit), maximum twelve digits (numbers).
    Date: YYYYMMDD, eight digits (numbers).
    Cost: minimum value = 1, no maximum value (rounded number).
    Password: up to 256 characters.
    A, B, C, D, E, F, G, H, I, J, K, L, M, N, P, Q, R, S, T, U, V, W, X, Y, Z,
    a, b, c, d, e, f, g, h, i, j, k, m, n, p, q, r, s, t, u, v, w, x, y, z, 2,
    3, 4, 5, 6, 7, 8, 9, =, #, (, ), *, +, -, _, \, @, [, ], {, }, %, $

    '*******process :
    Algorithms: verhoeff, base64, alleged RC4

    '*******result:
    Control code: generated from the aforementioned algorithms, it will be an alphanumeric data of up to ten characters, represented in groups of 2 separated by the character "-". Example: 7B-CD-23-04-12


    Example:

    '*******input data
    Authorization: 8004007852576
    Invoice: 50753
    DNI: 1048433012
    Date: 2008/08/19 = 20080819
    Cost= 91112.4 = 91112
    Password: jWzCH3JDJY5[-A{Cwg\Ew7B=ci_Z }(X6HUaZu8(u4}9 _Sz%cUWix+Vg7$r jD(qH Y

    '*******process :
    Algorithms: verhoeff, base64, alleged RC4

    '*******result:
    Control code: 1F-A8-98-84-1A
  • cactusdata
    Recognized Expert New Member
    • Aug 2007
    • 223

    #2
    But how?
    The Verhoeff algorithm, for example, generates a check digit for a number, so it cannot be related to or applied to the password.

    Comment

    • freemanthink
      New Member
      • Feb 2021
      • 2

      #3
      You're right, I think I got complicated up there. What I was trying to do is look for an encryption, using VERHOEFF, RC4 and BASE64, which asks for Internal Taxes of my country ... but I already solved the VERHOEFF problem. What I would like is; generate a cipher using the RC4 algorithm, VBA language. In such a way as to satisfy the following examples:

      example1.
      message: yK5K
      key: pPgiFS%)v}@N4W3 aQqqXCEHVS2[aDw_n%3)pFyU%bE B9)YXt%xNBub4@P Z4S9)ct21885
      algorithm: RC4 in VBA
      encryption: 6212AF1B

      example2.
      message: kvP8
      key: 442F3w5AggG7644 D737asd4BH5677s asdL4%44643(3C3 674F445644
      algorithm: RC4 in VBA
      encryption: 71D561C8

      the code of example 2, is separated, the correct thing is:
      Code:
      key: 442F3w5AggG7644D737asd4BH5677sasdL4%44643(3C3674F445644
      Note. I have tried using the algorithm posted by @Rabbit (https://bytes.com/topic/access/insig...m-vba-vbscript) but I can't get it to satisfy the above examples.

      Comment

      • Rabbit
        Recognized Expert MVP
        • Jan 2007
        • 12517

        #4
        The code in the article is fine. If you read it, the last paragraph explains why it won't match your situation. You just need to adjust it based on that.

        Comment

        Working...