INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Mapping null objects from a csv file

Mapping null objects from a csv file

(OP)
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!

RE: Mapping null objects from a csv file

This seems like a type tree problem.  Make sure Field3 is required with min value 0.
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close