Network PC/Network PC.iso/amiga utilities/applications/accounts/easycalc2.0f/examples/strings.calc

EasyCalc Spreadsheet file | 1997-11-20 | 1.4 KB | 45 lines

EASY30HED1
#'EasyCalc 2.0 - Example Worksheet 1
'String Functions
'Function Example
"Result
'=@CHR(65)
    =@CHR(65)
'=@COMPARE("A","B")
=@COMPARE("A","B")
'=@FIND("FREDDIE","RED",1)
=@FIND("FREDDIE","RED",1)
'=@INSTR("FREDDIE","red")
=@INSTR("FREDDIE","red")
'=@LEFT("FRED",2)
=@LEFT("FRED",2)
'=@LENGTH("freddie")
=@LENGTH("freddie")
'=@LOWER("FREDDIE")
=@LOWER("FREDDIE")
'=@MID("freddie",2,3)
=@MID("freddie",2,3)
'=@PROPER("mr freddie jones")
=@PROPER("mr freddie jones")
'=@REPEAT("fred ",4)
=@REPEAT("fred ",4)
'=@RIGHT("fred",2)
=@RIGHT("fred",2)
'=@STR(56.7)
=@STR(56.7)
'=@VAL("56.7")
=@VAL("56.7")
'=@UPPER("freddie")
=@UPPER("freddie")
D'New for EasyCalc 2.0, you can now compare and add strings together:
'="A" = "B"
="A" = "B"
'="A" <> "B"
="A" <> "B"
'="A" + "B"
="A"+"B"
'="A" > "B"
="A" > "B"
'="A" < "B"
="A" < "B"