Bit of a stupid question I guess but I've got the following....
0|Not Defined
2|On Hold
3|Tender
4|Award
5|On Site
6|Archived

in a field and I want to split field to rows, using the field to rows step and | as the delimiter sorta works but I need to keep the number associated with the record, can you use carriage return as the delimiter or is there a better way of going about this?

Cheers

Tom