Using IBM System i Access can I replace zeros with blanks in a downloaded CSV file?
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, 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
sending e-mail attachememt from mianframe – CSV format
Hi, Can you plesae let me know hos to do a semicolon seperator while doing this?
Answer Question
| May 11, 2010 7:04 PM
CSV, mainframes
Hi, Can you plesae let me know hos to do a semicolon seperator while doing this?
Answer Question
| May 11, 2010 7:04 PM
CSV, mainframes
Pipe Delimited CSV File
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
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?
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
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
cpytoimpf CSV file showing garbage
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 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
CSV to Access
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 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
How to match CSV field values in SQL Server 2005
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 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
convert csv file to pf file
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
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
Open XL file from ILE program
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
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
help on Bulk insert and xp_cmdshell rename
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
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
Auto download a .CSV file from network drive
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
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
Creating a CSV file to FTP
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 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
Format CSV file column width.
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 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
Code to upload CSV file to AS400
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
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 read in the comma delimited files by SAS
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
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
Importing addresses via .CSV as a new contact group
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
CSV
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
CSV
How to create a CSV file in PHP code?
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
CSV, PHP
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
CSV, PHP
Trying to run remote command to view AS/400 UNC and failing!
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
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
Script to extract files information from ftp server
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: 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
Script to extract files information from ftp server
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
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
