Jump to content

Delimiter on exported CSV file


Saubs

This topic is 3412 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello all,

 

I'm exporting CSV files from FM Pro 13 on a Mac, with the first row containing field names and the second row containing one record of data. Our client's business rules require that the end-of-record delimiter specifically be CRLF (Carriage Return + Line Feed) instead of just CR.

 

I've tried various export options/formats but FM seems to only give me CR as the delimiter. I imagine it can be done by post-processing the CSVs, but does anyone know if/how it can be accomplished natively in FM?  And if you have any suggestions for the post-processing approach, I'd be interested in hearing about that too.

 

Thanks very much--

Link to comment
Share on other sites

 

 

 And if you have any suggestions for the post-processing approach, I'd be interested in hearing about that too.

 

 

Since the export is on a Mac, you have a wide pick of OS-level technologies to do this: AppleScript, Shell script, Ruby,... whatever you are comfortable with / proficient in

This kind of post processing is fairly straightforward and fast.

 

In the scripted workflow in FM, you execute these through the Perform AppleScript script step or the Send Event script step.

Link to comment
Share on other sites

This topic is 3412 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.