Sage 100

Could I please get some help on the correct sytanx for a VI Job? I need to have quote marks and carriage returns import correctly. In my source file I have quote marks replaced with the ` symbol and carrage returns with the | symbol. I don't know how to create the syntax correctly with 2 replacements. This is what I have: SUB(IMP$[3],""`"",$22$)SUB(IMP$[3],""|"",$0d$) I check the Syntax in the Calculation expression and it passes. However, when I run the job I get an error 20 at line 142. If I only have one sub expression my VI job runs, so I know the problem is with how I have 2 calculation expressions instead of one.

SUB(SUB(IMP$[3],""|"",$0d$),""`"",$22$)

This worked perfectly .. thank you @BarbaraOlson

SUB(SUB(IMP$[7],""@"",$2C$),""~"",$22$) I'm doing another import job for another client, and the @ symbol is to import with a comma, and the ~ symbol is to import the "" quote mark; when I run my VI Job I get an Error 20 VIWXXX line 127. I don't understand what is wrong ... ideas anyone? The Temp field passed the syntax check in VI job maintenance.

OK, got the fix on this one. In this case I could not use ""~"" in the SUB logic, even though that is my character in the import text source file ... my new formula is: SUB(SUB(IMP$[7],""@"",$2C$),$7E$,$22$)