Re: Using CPYFRMIMPF

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

STRDLM(*DBLQUOTE) should handle those quoted strings.

On 6/3/2021 7:48 AM, Howie, Bill wrote:
> Hello all,
>
> I'm working on importing a CSV file to the IBM I using CPYFRMIMPF.  The file started out as an XLS file that I saved as a CSV file, and then did the CPYFRMIMPF.  Is there a foolproof way to handle the alpha fields that have commas as part of the data?  I know that saving the file as a CSV causes the data with commas in it to have double quotes around it.  These records all fall out into the error file that I'm using with the command.  Thoughts?  Any info is most appreciated.
>
> [Related image]<https://www.hc-companies.com/>Bill Howie
> Senior ERP Programmer/Analyst
> Direct: 330.487.3739 | Cell: 330.888.8085 | Toll Free: 800.225.7712
> 2450 Edison Blvd, Suite 3, Twinsburg OH 44087
> hc-companies.com<https://www.hc-companies.com/>
> Leader in Horticultural Containers
> [cid:image003.png@01D75853.DC09D240]<https://www.linkedin.com/company/the-hc-companies>   [cid:image004.png@01D75853.DC09D240] <https://www.facebook.com/HCCompanies/>    [cid:image005.png@01D75853.DC09D240] <https://www.instagram.com/hccompanies/>    [cid:image006.png@01D75853.DC09D240] <https://twitter.com/hc_companies>
>
> Disclaimer
>
> The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
>
> This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.