• conversion problem

    how do you convert DCF files into CSV files for export to Excel Spreadsheet

    ironpony45 pointsBadges:
  • Need to split the values in few cells in all the cells in CSV

    Need to split Database-A and 40005 and need to place Database-A in Column A4 and need to replace 1414 with 40005 in Column B4.   Column A  ColumnB URL Port Application-a.com 1414 Application-b.com 1414 website-x.com 25025 website-y.com 20208 Database-A,40005 1414 Database-B,40000 1414

    ManojD0595 pointsBadges:
  • Convert PST to CSV

    Can I convert a PST to CSV? If yes, how?

    awa2kee5 pointsBadges:
  • Output results of Hive query into CSV file

    We're trying to put the results of a Hive query into a CSV file. Here's the command we came up with: insert overwrite directory '/home/output.csv' select books from table; So, when it's done, it says completed but we can't find the file. Where is it? Or should we extract it in a different way?

    ITKE366,220 pointsBadges:
  • How to export big data from Cassandra to CSV

    My friend and I have been using Cassandra for storing big data (it's over 100 GB) in one column family. We're now trying to export it to CSV in a fast way but we're not being successful. We've tried CAPTURE and COPY but it's not producing what we need. Anyone know of a better way exporting...

    ITKE366,220 pointsBadges:
  • Merging Excel or CSV file to Active Directory

    How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?

    NewnanIT1,110 pointsBadges:
  • 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". The...

    Aiko2720 pointsBadges:
  • Zipping CSV to AS/400

    Hi I have one doubt in zipping the CSV files. I'm keeping the daily running reports in My IFS called ABC folder. wrklnk ABC. This folder contains 10 CSV files with date extension. Now I want to zip all this CSV files and FTP to another system. How to do this in AS/400? Please help me out in solving...

    iiiiiiiiiiiii335 pointsBadges:
  • Collect random data from PHP web form

    I need to collect data to compliment a voting PHP web form when it is filled in. Firstly, the data is sent to a CSV storage folder on the server and assigned its appropriate heading.[name, address, category etc] The file is downloaded weekly. The data is manually copied and pasted into its own...

    iainroome5 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:
  • How to extract a query to a CSV formatted file using SQL Plus

    I'm trying to extract several queries to a CSV output format. The only problem is that I can't use SQL Client or Oracle. I need to use SQL Plus. How can I do it?

    ITKE366,220 pointsBadges:
  • Create .csv file on IFS folder in AS/400

    Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).

    Samule400160 pointsBadges:
  • 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 don't have a delimiter. csv file: (First row is blank) apple bat cat doll when I used the below command:...

    GIG240 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught' SELECT...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to convert a csv file into a xlsx one?

    Hi, I'm generating a csv file from an open hub in BW so I need to convert it into a xlsx one due to I need to upload it into the Microsoft SharePoint. Is there an abap function that does it? I know that there is one to convert an xls one into a csv. Thanks

    VPD5 pointsBadges:
  • How can I split CSV strings in Oracle 9i?

    I'm trying to to split several CSV strings in Oracle 9i but I'm running into a few issues so I have a couple of questions: Is this possible in Oracle 9i? Do I need to create a new data type? Would I be able to declare the type within the function? Thank so much!

    ITKE366,220 pointsBadges:
  • 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

    ITKE366,220 pointsBadges:
  • Sequence information of mutltiple subforms in one form?

    I have one form embedded 3 subforms. I need to identify which subform is the top of the form because I need to write out the fields value to CSV in subsequently left top to right bottom as user can see on their PC.

    koseiarai5 pointsBadges:
  • CPYFRMIMPF – CSV to flat file. Getting all blank records.

    All records in the flat file are blank when performing a cpyfrmimpf. Copy file command is listed below. DTAFMT is *DLM, FLDDLM is ',' A sample from the file in IFS is listed below. What am I missing. CCSID of file in IFS is 1252. CPYFRMIMPF FROMSTMF('/ITG/OGAZIP/districtzip.csv')...

    dpitts4619495 pointsBadges:
  • 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 csv format. now my problem...

    Sanjeevgoyal5 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following