Substring Function

1

Hi Team,

I have a barcode containing three concatenated values without a separator. I need to split the different values and place them in the corresponding fields.

The barcode length is always the same, and all the values have the same length.

Example:

Barcode to scan: WOXX1G20950
Field 1: WOXX1
Field 2: G209
Field 3: 50

Which function do I have to use since I can’t use the “split” due to the absence of a separator ?
Much appreciated!

BR,
Safouane

2

@safe
You can use the “MID()” function like so:

image
image1287×485 13.2 KB

image
image2334×1058 112 KB

2 Likes
3

Hi @freedman, thank you very much!