change separator in data merge

Question

Hello,

i have a document which is use for invoicing my customers. My data comes form excell and i write to .csv file. Indesign does not recognize the standards separator ; but uses only ,

If is separate my date with only a comma, i wil have issues with date like these €53,97 How can i change the separator from a comma to a dot comma? Like this ;

Thanks

Srishti_Bali · Accepted Answer

Hi Ronald,I would like to know if the steps suggested by Erica worked for you, or the issue still persists.Kindly update the discussion if you need further assistance with it.Thanks,Srishti

Ronald Pronk · Answer

The problem seems to be everything which is saved from excell has a rights problem. Indesign cannot read the file, what ever it is. As soon is i open the file in a texteditor and sat it again indisign can handle the file. So i was looking in the wiring direction, the problem is not the seperator (which i replaced in a text editor) the problem is more file based. I never had this issue on my mac. I have a workflow which works for now i hope to find out what is the problem

Thanks for all the help!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded