Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mapping null objects from a csv file

Status
Not open for further replies.

shelts

Programmer
Feb 12, 2004
20
GB
I'm writing a map (Mercator vsn 6.71) to 'clean' a csv file that is sent with some fields containing commas or CR/LF values (which are the record delimiter and terminator respectively). The fields are surrounded by " marks (good old Excel).

After much messing around I've managed to get it written to do the above task, but it is failing at the last hurdle, which is to also map any fields that are null in the input (in order to accurately create a 'cleaned' copy of the file without the embedded commas or CR/LFs).

E.g. a record containing:
Field1,Field2,,Field4

maps as:
Field1,Field2,Field4

As you can see, the last field has shifted because of the lack of the null field on output, therefore completely changing the structure of the record.

The Group 'Track' parameter of 'Places' is supposed to fix this issue, but if the final group the text field is held in is 'Implicit' (which it needs to be for the map to work correctly)then this does not work.

I've even tried using the INDEXABS and CLONE functions to try and force it to write the NULL fields out, but it doesn't work.

Any ideas MUCH appreciated!
 
This seems like a type tree problem. Make sure Field3 is required with min value 0.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top