Solved

John, do you have a function to change the  pairs back to text?

Posted on 2016-10-04
3
28 Views
Last Modified: 2016-10-05
I had this question after viewing I need to convert a string into a string of decimals.
0
Comment
Question by:CRB1609
3 Comments
 
LVL 22

Accepted Solution

by:
Ferruccio Accalai earned 250 total points
Comment Utility
If you have used his TextToPair function it could by done as follows:
Public Function PairToText(InputString As String) As String
Dim tmpOutput As String
Dim strLen As Integer
Dim counter As Integer
strLen = Len(InputString)
For counter = 1 To strLen Step 2
tmpOutput = tmpOutput & CHR(CInt(Mid(InputString, counter, 2)) + 50)
Next
Debug.Print tmpOutput
PairToText = tmpOutput
End Function

Open in new window


Note that I've used 50 as value to add but if you used 30 as suggested in that q. you must change the value here too
tmpOutput = tmpOutput & CHR(CInt(Mid(InputString, counter, 2)) + 30)<---
0
 
LVL 13

Assisted Solution

by:John Tsioumpris
John Tsioumpris earned 250 total points
Comment Utility
Just follow the code above...but i would insist on the custom mappings...more secure and better to handle...
1
 

Author Closing Comment

by:CRB1609
Comment Utility
Thank you both, very much.

Clive
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now