1

CSV data format manipulation

view story
linux-howto

http://www.unix.com – Hi There I need a script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file. I am using an application that will only take data in a particular format and need something that will convert without manual intervention. The original data is in sample 1.csv and final output should look like something in sample 2.csv The very first line should start with a "ONE record," and should break after 9 commas. Then a "Child Record" should be created followed by the renaming characters from 9th comma on. I (HowTos)

Shoutmeloud's picture
Submitted by Shoutmeloud on 09/17/2012

Stories similar to CSV data format manipulation

Hello All, I need to convert a csv file to pipeline delimiter file in UNIX. The data in file itself contains comma with double qouted qualifier apart from the comma separator. Let me know how to do it.

Hi All,

I need to create a script to process on 10 files.

Data manipulation using shell 17 weeks 6 days ago

Dear all

I have a dataset (in text format,delimited by tab) which have 100 variables (say, var0-var99) and more than 100,000 observations. I want to do the following:

1. for variable var0-var49, I want to add "00" in front of each data (for example, "1" would become "001")

2.

Extract portion of data 49 weeks 6 days ago

Hi Gurus,

I need some help in extracting some of these information and massage it into the desired output as shown below.

I need to extract the last row with the header in below sample which is usually the most recent date, for example: 2012-06-01 142356 mb 519 -219406 mb 1 -77049 mb

Notice in the sampe output below, there a new column called: "Label" being added.

Delimited File to 2D Array 44 weeks 2 days ago

Hello,

I need help in fetching data from a delimited file , into a 2D array.

Sample Input File:

"|" as delimiter

Code: A|123|446pr; B|46|hello89 krp; C|78|ystp90 67; D|ga|456; Please be advised that ";" is the line separator (not "\n"). Could you please write an awk script to fetch this into a 2D array.

Output: array[0,1]=123

Thank You !

Hi. We are preparing to reprocess our data So we exported the old data into a csv file but in order to reprocess it, it has to be converted to a fixed block file which the current process understands.

I can get the Java AudioClip class to play sun '.au' sound files fine but I can't get my test wav file to play:

Quote:

file sample.au sample.au: Sun/NeXT audio data: 16-bit linear PCM, stereo, 8000 Hz

file pop.wav pop.wav: RIFF (little-endian) data, WAVE audio, Microsoft PCM, 16 bit, mono 44100 Hz

sample.au is a sample au file I got from the inter

Hello, I have a comma seperated data sheet with multiple fields of biological data. One column contains the ID name of the sample, where there could be more than one sample separated by a comma. I would like a script that reads this field, and for each sample ID, copies the entire line and writes it below.

[all variants] Saving data 3 years 8 weeks ago

Hi all, I have a new external HDD, and I want to save all my data from Windows XP on it, then drop XP and install Kubuntu.

The HDD was pre-formatted as FAT32. The manual recommends installing the "Turbo USB 2.0 Driver" to speed up data transfer.

Should I install the driver?