Replace Query ; with a ,

[Arlmachado]

Hello everyone,

I am trying to do a replace query on a column of my table, but it keeps giving me error. I believe it must be an error with the syntax.

I have attached what my column looks like below, and the type of fields there are. I always have a string of numbers plus letters, separated by a ";" and I wanted it to be a ","

How can I do that through a replace expression?

Any help is appreciated, thank you

 

[isladogs]

I'm going to recommend a different approach instead

Strongly recommend you do not use a multi valued field as it will cause you major issues handling data in the future

Each part should be stored as a separate record.
So you will have 3 records in place of each one you have now
BUT the database will work FAR better

To separate the records, you could use the Split function

 

[arnelgp]

use Update Query:


Update yourTableName Set yourTableName.[Bindongen] = Replace(yourTableName.[Bindongen], ";", ",")

 

[Arlmachado]

The problem is I don´t know how to do that unfortunately and the solution needs to be easily done. I have built forms and other stuff around databases like that, so the change as to be minimal. Which is why I just wanted to change ";" to a "," which was used in the last table I worked with.

 

[Arlmachado]

use Update Query:


Update yourTableName Set yourTableName.[Bindongen] = Replace(yourTableName.[Bindongen], ";", ",")

I have tried it like this:
Update 1 Set 1.[Bindungen] = Replace(1.[Bindungen], ";", ",")

but it says there is an error with the Set 1.[Bindungen] part.

 

[arnelgp]

no, it wont work. it is the semicolon is tied to your Computer's Regional setting.

 

[Arlmachado]

no, it wont work. it is the semicolon is tied to your Computer's Regional setting.

What does it mean, its attached to my regional settings?