Jump to content

Replace characters


This topic is 6693 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 "

Link to comment
Share on other sites

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,

"

Link to comment
Share on other sites

This topic is 6693 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.