• How to split large .CSV file into smaller files

    Our department has very one big .CSV file that needs to be broken up into smaller .CSV files using the command prompt. I've tried to write a batch script when I execute it. Can anyone help me solve this problem?

    ITKE440,700 pointsBadges:
  • Copy to CSV file and email out

    I need to copy orders to a CSV file and email out to customers. What's the best way to get this done?

    detrose15 pointsBadges:
  • Convert DTL file to CSV or Excel file

    Hi, How can I convert a DTL file to a cvs or excel file?

    Dtourso5 pointsBadges:
  • How to save Microsoft Excel worksheets as CSV files

    I have to analyze several Excel worksheets. Afterwards, I have to save them as .CSV files and I'm not sure how to do that. What's the best way to do it? Should I use a macro?

    ITKE440,700 pointsBadges:
  • Convert CSV file to MySQL table

    How can I convert my CSV file to my MySQL table? Furthermore - the first row of my data needs to be used as the column names. Thank you so much.

    ITKE440,700 pointsBadges:
  • Uploading .CSV spread sheet to AS/400

    When saving an excel spread sheet to .CSV, the numbers in the columns will look like this 1E+13 no matter how I format the file.

    UARTJ125 pointsBadges:
  • How can I convert CSV file to mt940 format in SAP ABAP?

    How can I convert CSV file to mt940 format in SAP ABAP?

    mike.oguh@firs.gov.ng15 pointsBadges:
  • Import .CSV file into SAP

    Is it possible to import a .CSV file into SAP without having all users exit SAP? Such as a sales order from another app I wish to export as CSV and have SAP import it. But we get many sales orders all day.

    Vision995 pointsBadges:
  • AS/400 – CSV files

    I'm using physical file (have 5 fields) to generate .csv file. But generated CSV (comma separate value) file having 6 fields, what is the issue? (this is interview question).. Please help me

    chowas400620 pointsBadges:
  • Excel to AS/400 PF

    I know this topic is widely discussed. But even after going through some of those discussion, I am not able to proceed. I have an Excel sheet which has one row header and one row of data, which includes both numeric as well as alpha data. I have opened it in notepad and but ',' separators after...

    RamvishakRamesh2,505 pointsBadges:
  • Importing a CSV file to an Oracle table

    We currently have a CSV file that we would like to import into an Oracle table. After it's loaded in, we're going to use the table for another use. Can this be done using SQLPLUS? Thank you very much.

    ITKE440,700 pointsBadges:
  • How to transfer Oracle table data to .CSV file by using PL/SQL coding

    How do I transfer Oracle table data to .CSV file by using PL/SQL coding?

    Tarick215 pointsBadges:
  • CPYFRMIMPF csv to PF – Encounter Data mapping error

    How to resolve the issue of using command CPYFRMIMPF to copy those records with blank date field in the csv file to be imported into PF?The date field in the csv file is '0000-00-00' and encounter error CPF5035 Data mapping error on member during the copy command and those records were ommitted.

    sjundesg5 pointsBadges:
  • Create CSV file from Actuate e.Report Designer

    How can I create a CSV file from Actuate e.Report Designer?

    VPL100 pointsBadges:
  • Need help to apply DACL security setting on OU to Trustee Group

    Somebody help me to write below values from CSV files apply same settings on OU for Group (Trustee)? The CSV file has below filed names ------------------------------------------------------------------------------------------------------------- Trustee_GroupName OUname       AccessMask...

    raajupv10 pointsBadges:
  • Get average through WRKQRY

    I have a file which has daily balances. I need to find the Average of the daily balance as the last record. I have selected the report summary functions from WRKQRY and have given (2=Average) on the desired field. I have selected the output type as 3 = data base file. After this if I take a F5 I...

    RamvishakRamesh2,505 pointsBadges:
  • STRPCCMD – How to avoid black DOS screen popup

    I have a STRPCCMD command in my CL program to open an IFS folder which has the .CSV files. STRPCCMD PAUSE(*NO) PCCMD(''''start " " "\'+%trim(P@SYSNAME)+%xlate('/':'':DFTPATH)+'"'')' P@Sysname has the system name. I can see a popup DOS window but getting message the path not found. I am able to see...

    RamvishakRamesh2,505 pointsBadges:
  • Java CSV reader (+charts)

    Hello there, I'm trying to create a Java web application which will do the following: -upload .CSV files -store them in a database -will display charts depending on the content of the .CSV file Any ideas? It HAS to be in JAVA! Thanks in advance, Peter

    pforos220 pointsBadges:
  • Script that can rename from CSV/serial join domain

    Hi, I'm after a script that would be able to rename a computer based on the machines serial number collected from the machine then i want it to look up the reference in a CSV file rename to the given name, add to the domain and reboot all automatically. Does anyone have such a script? I have this...

    IronHedge360 pointsBadges:
  • Performance improvement CPYTOIMPF

    Hi, I am using CPYTOIMPF command in my CL program to convert a database file to .CSV file. database file contains 3 million records and CPYTOIMPF command is taking 48 minutes to complete. Can some body kindly suggest me is there a way to improve the performance of the program. Thanks in advance. CV

    ZWANZIG40 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.