To transform data and carriage return

[chulett]

So, to get the date from a particular pair within the record:

Code: Select all

Field(Field(record,",",pair_number),"|",2)

The inner Field() call returns the pair--such as BBB|5/24/11--then the outer Field() call returns the date from that pair--5/24/11.

Exactly what I meant when I said "Inline Field() functions" and then described what to do first and second. Thanks James, although I was hoping Kiran would be able to work this out on his own...

[jwiles]

Yep, I know...however, it was becoming fairly obvious