curly
Full Member
Posts: 161
|
Post by curly on Apr 15, 2021 7:40:16 GMT -5
Hi again,
I have worked this out for myself and it works, but someone may want to tell me I've done it the hard way?
I haven't hard coded the reference data I use, but initially create them as .csv files. I am doing the same with the other files and completed jobs.
In order to get some protection, I have created an algorythym to change each character to a differnt one, and use one of the unusual printable extended ascii charaters in place of a comma to identify the end of each string of data. Is there a better way?
|
|
|
Post by Chris Iverson on Apr 15, 2021 11:35:35 GMT -5
Not really, you've pretty much nailed the essence of what encryption is.
|
|
curly
Full Member
Posts: 161
|
Post by curly on Apr 15, 2021 11:43:43 GMT -5
Thank you very much, happy days!
|
|
curly
Full Member
Posts: 161
|
Post by curly on Apr 18, 2021 4:05:28 GMT -5
I still have a query with regard to encryption. I can save my encrypted file in csv format OK placing a character of my choise in place of the comma when writing to a file, but when reading it in, it looks as if I need to read the entire file in as a single string, and then split it up, or read in a single charater at a time, looking for my special charater?
Is there a way the file can be read as if it is a regular csv file, but looking for a different character in place of the comma?
Kind regards, David
|
|
|
Post by Rod on Apr 18, 2021 7:48:05 GMT -5
Well you could read it into a string and use replstr$() to replace your character. But you would need to save it out to file again to use inputcsv$(). To keep the encryption read in the entire file then work through it using word$() with your special character as the separator.
|
|
curly
Full Member
Posts: 161
|
Post by curly on Apr 18, 2021 14:28:46 GMT -5
Hi Rod, thank you very much, never heard of word$(), so I'll get reading!
|
|
|
Post by Brandon Parker on Apr 20, 2021 22:43:38 GMT -5
You could also check out InputTo$(#handle, delim$)) in the help file.
{:0)
Brandon Parker
|
|
curly
Full Member
Posts: 161
|
Post by curly on Apr 21, 2021 7:22:37 GMT -5
Hi Brandon, using InputTo successfully thank you very much. JJust about to post yet another plea for help
|
|