Functions in Ramp EDI Tool

[Sarah Ross]

Functions:
Prepend value to front of field
This can be done with the use of PREPEND
Type Data
PREPEND 0
Factor
1
Parameters
Type Position Name
Input 1 InputField
Output 1 OutputField
Result:
InputField: 123456789
OutputField: 0123456789
To change a value of a code being sent in
This can be done with the use of a temporary table (MS SQL version table name is implied and in UNIX version use )
Type
SQL
Database Resource Name
RAMP_MSSQL
Command
SELECT CASE ?
WHEN “05” THEN “AA”
WHEN “55” THEN “BB”
WHEN “ZZ” THEN “02”
WHEN “AR” THEN “99”
ELSE ? END
Parameters
Type Position Name
Input 1 InputCode
Input 2 DefaultCode
Output 1 NewCode
Result:
Case 1
InputCode “ZZ”
DefaultCode “BB”
NewCode “02”
Case 2
InputCode “DD”
DefaultCode “88”
NewCode “88”