Replace Query ; with a , (1 Viewer)

Arlmachado · Dec 13, 2017

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 · Dec 13, 2017

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 · Dec 13, 2017

use Update Query:

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

Arlmachado · Dec 13, 2017

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 · Dec 13, 2017

arnelgp said:
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 · Dec 13, 2017

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

Arlmachado · Dec 13, 2017

arnelgp said:
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?

Replace Query ; with a , (1 Viewer)

Arlmachado

Registered User.

Attachments

isladogs

MVP / VIP

arnelgp

..forever waiting... waiting for jellybean!

Arlmachado

Registered User.

Arlmachado

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Arlmachado

Registered User.

Similar threads

Users who are viewing this thread