How to remove Barcode Prifix and Suffix

[Ed Dror]

Hi There,

Im using 2D barcode on the internet and
When I scan the barcode the first record in my form start with {some text
And the last record end like sometext}

How do I remove these two characters { } ?

Thanks,
Ed Dror

 

[John W. Vinson]

Hi There,

Im using 2D barcode on the internet and
When I scan the barcode the first record in my form start with {some text
And the last record end like sometext}

How do I remove these two characters { } ?

Thanks,
Ed Dror

You can run an Update query updating the field to

Replace(Replace([fieldname], "{", ""),"}", "")

or - perhaps more efficiently - an Update query such as

UPDATE tablename
SET fieldname = Mid([fieldname], 2, Len([fieldname]) - 1))
WHERE fieldname LIKE "{*}";


John W. Vinson [MVP]

 

[Ed Dror]

John,

Thanks, It works

Ed Dror

Hi There,

Im using 2D barcode on the internet and
When I scan the barcode the first record in my form start with {some text
And the last record end like sometext}

How do I remove these two characters { } ?

Thanks,
Ed Dror

You can run an Update query updating the field to

Replace(Replace([fieldname], "{", ""),"}", "")

or - perhaps more efficiently - an Update query such as

UPDATE tablename
SET fieldname = Mid([fieldname], 2, Len([fieldname]) - 1))
WHERE fieldname LIKE "{*}";


John W. Vinson [MVP]