My user insert a hash or a sequence of 48 digits. For example 846900000015259602962021103150630004002081451896 using this formula after saved value(MID(A1103;5;7)&mid(A1103;13;2)&","&mid(A1103;15;2)) get the amount of this bill R$125,96 826500000011699901066406457784431910522700000006 in this R$1…

Do you happen to know much about how the barcode is formulated? I know most barcodes have certain positions that mean different things, such as amount, account number, and other pieces of information…sometimes to control the machinery that folds the paper and stuffs envelopes…or mark the beginning …

[image] Jeff_Hager: Do you happen to know much about how the barcode is formulated? I know most barcodes have certain positions that mean different things, such as amount, account number, and other pieces of information…sometimes to control the machinery that folds the paper and stuffs envelopes…

I guess what I’m trying to understand is the structure of the barcode and how it’s created. Something like this??? Layout_Boleto_BB_V1.0.pdf 503.72 KB If I understand that, then I can understand how to generate that check digit in the middle of the amount an…

Here, try putting this in a Math Column and see how consistently it works. ( TRUNC( TRUNC( ((Code / 100000000000000000000000000000000 / 1000000000000) - TRUNC(Code / 100000000000000000000000000000000 / 1000000000000)) * 1000000000000 ) / 100000) + MOD( TRUNC( ((Code / 100000000000000000000…

Oh my someone said u r genius! it’s truth! I’m gonna try later.

Sure we do. [image] Chuck Norris aka Jeff Project Showcase Jeff has unlimited rows in his Glide Apps, because Jeff knows no bounds. Jeff sometimes has problems with if-then-else “is equal to”, because Jeff has no equal. Jeff’s apps don’t run slowly, because they know how …

Holy moly Jeff! I try not to be surprised, but it gets hard … haha you can always do it! Stunning man

I introduce you Mr Chuck “Jeff” Norris! :sunglasses:

How can I get it MID() formula to show part of info before saving?

Ask for Help

Lucas_Pires May 17, 2021, 5:17pm 7

Sure we do.

Topic		Replies	Views
Reading parts of string with 20 numbers Ask for Help	15	1018	July 27, 2020
Only accept starting with 8 no dashes or dots or spaces Ask for Help	18	957	May 16, 2021
Leitor de codigo de barras Ask for Help	8	1526	February 23, 2021
Numero de Pedido Ask for Help	5	213	November 22, 2021
Printing Barcodes Generated In Glide Ask for Help	0	21	March 5, 2025

How can I get it MID() formula to show part of info before saving?

Related topics