Some formulas used in Barcode Label Pro

The barcode label program is very flexible. You can apply a large number of mathematical formulas and print them serially from your printer.

These formulas include text-to-number, number-to-text, number-to-text, time, day, minute and date stamping, currency penny formatting, random number generation, number rounding, currency conversion, logical value assignment, case conversion, left or right cropping, automatic counter.

---

You can see how formulas are written and how they produce results in our examples below.

Type transformation:

FROM NUMBER TO WRIT(number)

Takes a single numeric parameter and converts the numeric field to a text field.

Example: NUMERICTEXT(123.45) =123.45

INtegerWrite(number)

Takes a single numeric parameter and converts an integer numeric field to a text field.

Example: NUMERICTEXT(123) =123

SUMMERNUMBER(text)

Takes a single text parameter and converts the text to a number.

Example: YAZIDANSAYIYA(‘123,45’)=123.45

textNUMBER(text)

Takes a single text parameter and converts the text to integer.

Example: YAZIDANTAMSAYIYA(‘123’)=123

Time:

MONTH( DATE )

Takes a single date parameter and returns the month of the date.

Example: MONTH( DATE )=3

MINUTE(datetime)

Takes a single date parameter and returns the minutes of the date.

Example: MONTH( DATE )=55

GUN(datetime)

Takes a single date parameter and returns the day of the date.

Example: MONTH( DATE )=13

HOURS

It does not take any parameters. Returns back the clock.

Example: 12:15:33.

SECOND

Takes a single date parameter and returns the second of the date.

Example: MONTH( DATE )=55

DATE

Does not take any parameters. Returns a back date.

Example: 25.03.2012.

YEAR(DATE)

Takes a single date parameter and returns the year of the date.

Example: MONTH( DATE )=2012

Mathematics:

EUROYAZ(number)

Takes a single numeric parameter and returns formatted.

Example: EUROYAZ(125.33) = € 125,33

KURUSYAZ(number)

It takes a single numeric parameter and returns the number in cents after the comma.

Example: KURUSYAZ(12.44)=44

MOD(number,number)

It takes two numeric parameters and returns the remainder of the first number divided by the second number.

Example: MOD(12,5)=2

POSITIF(number)

Takes a single numeric parameter and returns the absolute value of the number.

Example: EUROYAZ(-5) = 5

RANDOM(number)

It takes a single numeric parameter and returns a number up to the given number.

Example: EUROYAZ(12) = 5

NUMBERFORMATATE(text,text, number)

Takes two text and an odd number as parameters and formats the number according to the given values.

Example: COUNTIFORMATLA(#0,’ TL’, 125456.45)=125.456 TL

FULLWRite(number)

Takes a single numeric parameter and returns the whole number.

Example: INTEGER(12.56)=12

TLYAZ(number)

It takes a single numeric parameter and returns 2 penny digits in TL format.

Example: TLYAZ(125.35)=125,35 TL

USDYAZ(number)

It takes a single numeric parameter and returns 2 penny digits in $ format.

Example: TLYAZ(125.35)=$ 125,35

ROUND(number)

Takes a single numeric parameter and returns an integer.

Example: ROUND(12.43)=12

ROUND(12.55)=13

Interrogation:

EGER(logical, text, text)

A logical takes 2 text parameters and returns the first text parameter if the logical value is true and the second text parameter if the logical value is false.

Example: EGER(1>0, ‘TRUE’, ‘FALSE’)=TRUE

Formula:

ENLARGE(number,…)

Takes multiple numeric values and returns the larger number.

Example: ENBUYUK(12,5,41)=12

LITTLE(number,…)

Takes multiple numeric values and returns the smaller number.

Example: ENBUYUK(12,5,41)=5

AVERAGE(number,…)

It takes multiple numeric values and returns the average number.

Example: AVERAGE(12, 5,4)=7

SUM(number,…)

Takes multiple numeric values and returns the sum of the numbers.

Example: SUM(12,5,41)=21

Text:

BUYUKHARF(text)

Takes a single text parameter and returns the given text value in uppercase.

Example: UPPERCASE(‘text’)=TEXT

TRIM(text)

Takes a single text parameter and deletes spaces to the left and right of the returned text value.

Example: TRIM(‘ text’)=text

COPY(text, number, number)

Takes a text and two numeric values. Returns the given text value starting from the 1st numeric value and copying it up to the 2nd numeric value.

Example: COPY(‘Barcode Label Pro’,1,6)=Barcode

KUKUKHARF(text)

Takes a single text parameter and returns the given text parameter in lower case.

Example: LOWERCASE(‘Text’)=text

LEFTANKIRP(text)

Takes a single text parameter and returns the text value with the spaces to the right of the given text value removed.

Example: LEFTWORDKIRP(‘text ‘)=text

LEFTANKIRP(text)

Takes a single text parameter and returns the text value with the spaces to the left of the given text value removed.

Example: LEFTWORDCIRP(‘ text’)=text

RIGHTCOPY(text,number,number)

Takes a text and two numeric values. Returns the given text value starting from the right of the 1st numeric value and copying it up to the 2nd numeric value.

Example: LEFT COPY(‘Barcode Label Pro’,10,1)=Label Pro

LEFT(text,number)

Takes a text and a numeric value. Returns the given text value by copying the numeric value from the far right.

Example: LAGDAN(“Barcode Label Pro”,5)=t Pro

LEFT(text,number)

Takes a text and a numeric value. Returns the given text value by copying the numeric value from the leftmost position.

Example: LEFT(“Barcode Label Pro”,5)=Barcode

LEFTFILL(text,text,number)

Takes two text and one numeric value. Returns the text value to the right of the given 1st text value by adding it to the sum of the given numeric value.

Example: SAGINADOLDUR(“ABC”,”0″,10)=ABC0000000
Example: SAGINADOLDUR(SAYAC(1,1),”0″,5)=10000

LEFTFOLD(text,text,number)

Takes two text and one numeric value. Adds the numeric value to the left of the given 1st text value and returns a sum equal to the given numeric value.

Example: SOLUNADOLDUR(“ABC”,”0″,10)=0000000ABC
Example: SOLUNADOLDUR(SAYAC(1,1),”0″,5)=00001

Counters

COUNTER(number,number)

It takes two numeric values and counts down starting from the first value and incrementing by the second value.

SAYAC returns the same count for each tag iteration.

Example: SAYAC(1,1)

COUNTERGENERAL(number,number)

It takes two numeric values and counts down starting from the first value and incrementing by the second value.

SAYACGENEL returns a different number for each tag iteration.

Example: COUNTERGENERAL(1,1)

#ETIKETNO

It takes no parameters and gives the number of that label in the printout without looking at the label repeat.