Safe String Code

Hey,

How to make function which removes all unsafe charters, removes spaces, converts international letter to latin etc, and retuns only latin letters and numbers (alphasimbols)?

Also this function should reduce lenght of the string to n simbols.

ETC.:

dim str as string = "<*> Hello 10 people, how are you!? <*>"
str = myfunction(str, 8)

And then Str value is equl to = "he10phay"
If lengt of string is more then 8 after removing unsafe charters, it cuts some characters of every world until it's lengt is 8.

Any suggestions?

Maybe .NET has function which convers string to alpha string?

I don't know how to do that but Regular Expression can help you .

Quote:

---

Originally posted by Norkis
Hey,

How to make function which removes all unsafe charters, removes spaces, converts international letter to latin etc, and retuns only latin letters and numbers (alphasimbols)?

Also this function should reduce lenght of the string to n simbols.

ETC.:

dim str as string = "<*> Hello 10 people, how are you!? <*>"
str = myfunction(str, 8)

And then Str value is equl to = "he10phay"
If lengt of string is more then 8 after removing unsafe charters, it cuts some characters of every world until it's lengt is 8.

Any suggestions?

Maybe .NET has function which convers string to alpha string?

---

Heavens! Your mind is even more twisted than mine:bigyello: Let's have a go.

1. "How to make function which removes all unsafe charters, removes spaces,"

Compare each character with the appropriate range of ASCII values and reject as necessary.

2. "converts international letter to latin etc, and retuns only latin letters and numbers (alphasimbols)?"

Not sure what you mean. i.e. convert e.g. Cyrillic script to Latin? Convert Arabic to Latin? Convert Chinese to Latin?

3. "Also this function should reduce lenght of the string to n simbols"

Find the length of the converted string: divide it by n: get each n th character from the string.

May I ask the purpose of this?:confused:

I'm creating universal registration form, whis stores all data in DB.

Then user create new field, he enters it's title.
Title can consist anything, like "‡ Surname (Pavardë) Ñ"
I cant create table with column name like this title, so I want to convert it so safe, but readable for me.

Hum, I think it would be large funtion, with several loops...
No way to make it shorter?

Quote:

---

Originally posted by Norkis
I'm creating universal registration form, whis stores all data in DB.

Then user create new field, he enters it's title.
Title can consist anything, like "‡ Surname (Pavardë) Ñ"
I cant create table with column name like this title, so I want to convert it so safe, but readable for me.

Hum, I think it would be large funtion, with several loops...
No way to make it shorter?

---

But surely the user will want to see the field name as he originally entered it? So, why not create a table which holds in one column the name as entered (as many characters as entered); in another column the name you allocated (8 characters long); in another column the table to which the names refer. Then, when you want to display the information in future, you simply have to cross reference.

This is exactly what I'm doing. :)

Quote:

---

Originally posted by Norkis
This is exactly what I'm doing. :)

---

Then the quickest way would be to keep note of how many columns are being created and name them Column1, Column2 ..etc e.g. strCol="Column" & str(val(iCol)) (or use casting if you prefer)

But then it would be harder, if I have to modify something manualy.

Quote:

---

Originally posted by Norkis
But then it would be harder, if I have to modify something manualy.

---

Sorry, I don't follow you. You will have just simplified the way of naming your data table column. Nothing else will be different.

Ok. I tryied to name my columns in simple way (column1, column 2 ...)

Now I got new problem:

Imagine, That I create two fileds (columns).
It will be Column1 and Column2 (Column name consists word "Column" & item.index in datalist)
Then I remove the first one, so there are only Column2 left.
I got error, when I try to add new one, becource the name Column2 already exist.

How to solve this?

Quote:

---

Originally posted by Norkis
Ok. I tryied to name my columns in simple way (column1, column 2 ...)

Now I got new problem:

Imagine, That I create two fileds (columns).
It will be Column1 and Column2 (Column name consists word "Column" & item.index in datalist)
Then I remove the first one, so there are only Column2 left.
I got error, when I try to add new one, becource the name Column2 already exist.

How to solve this?

---

hI,

How about using an autonumber as your key field in the reference table we referred to and using that as the addition to "Column":bigyello:

Good idea! :) Thanks