Field(Orders.RecIn,"","",2) = RecType

[samsuf2002]

this is due to low memory adding an environment variable

add APT_DISABLE_COMBINATION and set it as true might help try it

[ArndW]

The Field() function only has 3 parameters, the string, the delimiter and the occurrence number.

[ray.wurlod]

The Field() function may have three or four arguments, Arnd. The fourth is number of fields to return.

However, I do not believe that the third argument for Field() can legally be a string; it must be an integer. Therefore, assuming that you've read the entire source record (RecIn) as a VarChar and want to return the second comma-delimited field from it, the correct specification is

Code: Select all

Field(InLink.RecIn, ",", 2, 1) 

or more simply

Code: Select all

Field(InLink.RecIn, ",", 2)

[venkat_kp]

Thank you all for the info. But still the result is the same

Yes read the entire source record (RecIn) as a VarChar and want to return the A, second comma-delimited field from it.

When Field(InLink.RecIn, ",", 2, 1) is used it's pulling only
"
"
"
"
"
"
and with Field(InLink.RecIn, ",", 2) job is getting aborted with
the previous messages.

[ray.wurlod]

You need to reduce the string so that it can fit into Char(1). Since you're reading the entire line as a single string, the Field() function is returning the quote characters as well as the quoted value. Therefore you also need to Trim() the quote characters from the result of the Field() function.

[keshav0307]

And what is stopping you to read as comma delimited with double quote

[ray.wurlod]

The fact (already stated) that the entire record has been read as a single string, presumably because the file contains more than one record type. Note the name of the field that is being attempted to be extracted.

[ArndW]

The Field() function may have three or four arguments, Arnd. The fourth is number of fields to return.

I shouldn't have tried that without having a BASIC to check; for some reason I thought that PX didn't allow the 4th arg. But the arguments were incorrectly ordered as well in the OP.

[venkat_kp]

After removing the quotes in the source and retyping the derivation (Field(InLink.RecIn, ",", 2) it worked.

Thank you all.