How to remove Barcode Prifix and Suffix

  • Thread starter Thread starter Ed Dror
  • Start date Start date
E

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
 
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
Click to expand...

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]
 
John,

Thanks, It works

Ed Dror

John W. Vinson said:
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
Click to expand...

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]
Click to expand...
 
Back
Top