Extraction format/layout

We don’t have this problem but I think you can get around it by using the =CONCATENATE function in the .CSV file.

If your email addresses are in columns D, E and F if you insert a column (H for example) and put in the first cell =CONCATENATE(D1,E1,F1) and filter down to the last record then resave the .CSV file then you can use column H as your email field as it will have all the email addresses in it from the three possible columns.

It doesn’t say why there is a problem but it’s a cheat to solve it.

Thanks

I must admit I always tend to use Tab-delimited rather the CSV files.
People rarely add tabs to names and addresses whereas commas can be more prevalent and sometimes if the fields aren't correctly encapsulated in quotes (or read correctly in quotes) then these will cause the fields to split, giving you the kind of problem you are seeing.

The only problem I have had with extractions output (using tab delimited) is when someone has managed to enter a Carraige Return into one of the address fields, which causes half the field to drop a line, this mainly only happens when pulling addresses for direct mail.

Mark

Hi guys,

Another extraction related question!

When I pull Extractions and convert them to CSV files in Excel, I find that the email addresses don't display in the same column, some display in one column and other display in the column next to it. With a smaller Extraction it's not a problem to manually adjust them but with an Extraction in the 1000's this is not possible. Does anyone know how this issue can be resolved?

Thanks, Sam

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!