MySQL Forums
Forum List  »  Newbie

Re: Convert ANY to 16 digits number
Posted by: Peter Brawley
Date: August 01, 2019 12:55PM

Pseudocode for such a func would be ...

1 concatenate the 3 input strings

2 walk the string char by char, copying only digits to a new string

3 every 4th digit unless it's the last input char, add a hyphen

4 stop at 16th or 24th digit depending on input argument

5 Return the result string

Straightforward coding, just needs concat() substr() calls and a do...while loop with counters.

Options: ReplyQuote


Subject
Written By
Posted
Re: Convert ANY to 16 digits number
August 01, 2019 12:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.