Hi, I have a simple file transfer from my iSeries(AS/400) to a CSV file. I have a numeric field with 2 decimal places. The file is sent to an outside agency. They need zero values to contain blanks. Is there a way to do this? Thanks for your help.
Answer Question | August 12, 2010 3:01 PM
AS/400, CSV, CSV file format, iSeries
Hi, Can you plesae let me know hos to do a semicolon seperator while doing this?
Answer Question | May 11, 2010 7:04 PM
I have the following Pipe Delimited data in a physical file: Dealer Name¦Deal Number¦Buy/Sell¦ Joseph Camm¦80740¦S¦IG¦5000000.00¦ After issueing a CPYTOPCD command, I end up with: Dealer NameÝDeal NumberÝBuy/SellÝIG1ÝAMOUNT_amountÝ David CammÝ80740ÝSÝIGÝ5000000.00Ý How do I get around this?
Answer Question | December 24, 2009 11:32 AM
CL Commands, CL programming, CSV, CSV file format, File conversion programs, File formats, File Transfer Protocols
Can you explain what cluster shared volumes are? Is this a new file system? This question is from the 7/30 Microsoft Virtualization Chat on ITKnowledgeExchange.com
Answer Question | August 21, 2009 9:23 PM
Cluster Shared Volumes, CSV, Microsoft virtualization, Microsoft Virtualization Chat 7/30
I have an application that does 3 CSV files to import to Excel. All three use the same cpytoimpf program/command, 1 is working correctly and 2 are not. I debugged and do not see a difference. I can view the data just fine with dsplnk on the iSeries/AS/400 but the Excel is all @@@@@@. Does [...]
Answer Question | July 2, 2009 12:51 PM
CPYTOIMPF, CSV, IFS
I have multiple csv files in a folder with many lines of data in them. Every day new csv files get added to this folder. I want to write batchfile to copy certain rows from these files to the access database table everynight automatically. How can I do this?
Answer Question | April 1, 2009 7:56 PM
CSV, Microsoft Access
i have an table in sql-server 2005, in which my one field is storing csv values. suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in [...]
Answer Question | March 26, 2009 7:18 AM
CSV, CSV file format, CSV format, SQL Server 2005
i have a file on IFS in .csv format.how to copy this file to pf format in another library.
Answer Question | March 12, 2009 4:10 PM
AS/400, Converting CSV to PF, CSV, PF
We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? [...]
Answer Question | March 11, 2009 8:00 PM
CSV, IFS, ILE, ILE Program, Microsoft Excel
Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows.I dont have a delimiter. csv file: (First row is blank) apple bat cat doll when i used the [...]
Answer Question | March 5, 2009 6:49 PM
Bulk Inserts, CSV, SQL INSERT, T-SQL
to a AS/400 physical file through a cl program? how can I do this?
Answer Question | February 13, 2009 6:09 PM
CL Program, CSV, Physical File
I just loaded Office 2007 and created a csv file which then was FTP’ed to a server. When picked up it had lost its csv extension. I follow this process regularly and this only happened after I upgraded to 2007. Any ideas?
Answer Question | February 8, 2009 4:56 AM
Comma Separated Values, CSV, CSV format, Excel 2007, FTP, Microsoft Excel 2007, Microsoft Office 2007
I converted a dataset to a CSV file and found when opening the file, all the column widths are fixed. This causes most of the columns to be truncated. Is there a way (not manually) of making the columns auto-fit. Language: Cobol.
Answer Question | August 31, 2009 8:01 PM
CSV, CSV file format
I am looking for code to convert .CSV file to AS400 automatically. I need to automate this feature. Thanks in advance.
Answer Question | January 7, 2009 5:46 PM
CSV, CSV to AS400
How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed “sheet 1″ and second for the sheet tabbed “sheet 2″? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read [...]
Answer Question | February 9, 2010 5:36 PM
CSV, Delimited function, Microsoft Excel, SAS
I am working on sending out a mass email based on a list of names received as a .csv. I have converted this file to a .wk4 and a .wk1 and I am able to import the names, however, when trying to import the names as a group they appear as seperate contacts. Is there [...]
Answer Question | November 12, 2008 8:08 PM
I need to create a physical CSV file from PHP code. I have many solutions to get the results to print to a screen, but I need a file… any ideas?
Answer Question | April 19, 2013 6:03 PM
I need some ideas here…I’m stuck. I’m running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files [...]
Answer Question | August 15, 2010 7:54 PM
CSV, Microsoft Excel, RPG, UNC, UNC path
Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it’s easiest) which when run, it will: 1. Log on to a ftp server using a generic account and password 2. It then find the files (no downloading) in a specific folder that [...]
Answer Question | September 24, 2008 9:33 PM
CSV, FTP, FTP Server, Microsoft Excel, Scripts
Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it’s easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string “abc”. [...]
Answer Question | March 19, 2009 9:34 PM
CSV, FTP, FTP Server, Microsoft Excel, Scripts