Delete quote
BENOIT
Forums
I have in my database a caracter's field wich contains sometines quotes.
exemple : JOURNAL DES "A NOUVEAUX"
I'm trying to replace or delate quote " by the following function but it doesn't work :
Set db = Client.OpenDatabase(DBNAME)
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "JOURLIB2"
field.Description = ""
field.Type = WI_VIRT_CHAR
a= "@Replace(JOURNALLIB;" & Chr(34) & Chr(34) & Chr(34) & ";"" "")"
field.Equation = a
field.Length = 100
task.AppendField field
task.PerformTask
Set task = Nothing
Set db = Nothing
Set field = Nothing
I tried the function @remove but I didn't succeed to handle the quote.
anybody has an idea ?
Thanks
Hi Benoit,
Hi Benoit,
Try the following as your equation so replace the:
a= "@Replace(JOURNALLIB;" & Chr(34) & Chr(34) & Chr(34) & ";"" "")"
with
a = "@Replace(REMOVE_FIELD; @chr(34), """")"
the @char(34) in the equation returns the double quotes.
Brian