Remove {" at beginning of text

  • Thread starter Thread starter Clemens
  • Start date Start date
C

Clemens

I have a table with several text fields.
Each cell with text starts with {"
The text is closed with "}

When in a text only a double closed quote is used this must not be removed.
So only in the combination mentioned above.

I have allready created a switchboard and a button performes also other
functions, like delete all records and import an excel file.

What code do I need to remove {" or "}
 
Not sure that's a full answer:

I'd use this:

UPDATE mytable SET[myfield] = replace(replace([myfield],"""{",""),"}""","");
 
Hi Clemens,
you can use also the replace function as follows

UPDATE mytable SET mytable1.myfield = replace([myfield],'{"',"")

HTH Paolo
 
Sorry my quotes were in the wrong place

should be

UPDATE mytable SET[myfield] = replace(replace([myfield],"{""",""),"""}","");

Note that all of those quotes are there as to create a literal quote in a
string you have to double it, hence a string that says Hello "World" would
come out as "Hello ""World"""



Not sure that's a full answer:

I'd use this:

UPDATE mytable SET[myfield] = replace(replace([myfield],"""{",""),"}""","");
I have a table with several text fields.
Each cell with text starts with {"
Click to expand...
[quoted text clipped - 7 lines]
What code do I need to remove {" or "}
Click to expand...
Click to expand...
 
Back
Top