Replace characters

[greinick]

Hi,

I have an adress database with name and forname. This are normal textfields. The values contain among other things umlauts.

Now I'd like to generate UserIDs from the two values. At the moment I can generate a third feeld containig the first letter of the forname and max. seven of the name.

But I don'l want ulauts etc. in the UserID.

Is there a way to replace all

[Reed]

You could use the substitute function

Substitute(textField,

[greinick]

Thank you - Hm... thats what I found out for one character; at the moment my formel looks like this:

Links(Austauschen(Vorname; "

[Lee Smith]

Try this.

You will need to change the Substitute to the German equivalent, and also replace the commas with semicolons. If this works, you then will need to add a "Substitute(" in front of the calculation, and your next value at the end of the calculation (i.e. put a comma or semicolon behind the last entry and add your next values such as this "

[greinick]

Thanks! This helped in some way, but now I have the problem that if an users name contains Umlauts, they are replaced after the UserID is generated.

e.g.

[Lee Smith]

If I'm understanding you correctly, you will need two fields to act as an intermediary to the Concatenating of the fields.

In other words, one field for Vorname

c_vorname (Calc, Text Result) =

Substitute(Substitute(Substitute(

Left(Vorname, 1,

"