Question: You have a table and the source data looks like this: Given that: The first 6 bytes represent the PO Box number of the vendor
You have a table and the source data looks like this:
Given that:
The first bytes represent the PO Box number of the vendor
The next bytes represent the Vendor Number
Both fields PO Box Number, Vendor Number have been defined with an ASCII data encoding
How would you create one field comprised of the PO Box number and the vendor number? The created field will contain numbers. Select all that apply.
a Without deleting either field, highlight the first numbers in the table layout.
b Create a computed field concatenating the two fields using the symbol.
c Create a computed field concatenating the two fields using the CONCAT function.
d Delete both fields because you cannot define data twice and then highlight the first numbers in the table layout.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
