1

Adding a delimiter to a variable length file

view story
linux-howto

http://www.unix.com – Hi, I'm new to unix, i have a variable length file like below, Code: 01|Test|Test1|Sample| 02|AA|BB|CC|DD| 03|AAA|BBB|CCC|DDD|EEE|RRR|TTT|SSS|YYY| I need to make this as a fixed length file. Assume that i have 10 columns in the DAT file. for ex: the first 01 record is having 4cols - there i need to add six "|" delimiter and for 02 record need to add five delimiters. Like wise i need to read few record number and add the delimiter correspondingly.. Can anyone help me on this regard. your help would be much appreciated.. Thanks in advance, Mohankumar.V (HowTos)

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

Stories similar to Adding a delimiter to a variable length file

Vb file from UNIX to mainframe 17 weeks 16 hours ago

Hi Everyone,

Do I need to provide record length as Record length + 4 when I'm transferring a variable block files from unix to mainframe through ftp? For example, I have a file in unix (ebcidic converted) with maximum record length of 100.

Hi,

The declaration for directory record length in ext2 filesystem is as follows:

Code: #define EXT2_NAME_LEN 255

struct ext2_dir_entry_2 {   __u32 inode;      /* Inode number */   __u16 rec_len;    /* Directory entry length */   __u8  name_len;  /* Name length */   __u8  file_type;   char  name[EXT2_NAME_LEN];  /* F

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.

Need Help _ Unix Script 32 weeks 3 days ago

Hello,

I have one requirement. We are getting fixed length file with trailer record on it. We need to cleanse,validate and process the file.

As part of validation we have to do duplicate file check based on file name and trailer record.

I want to add the file name as last column to file, so that I can use the filed for validation purpose.

Help regarding the delimiter 1 year 13 weeks ago

Hi,

I am trying to load data from a file to oracle DB. The file am using has a ";" as a delimiter. While I load the file, I want to check whether the file is having the correct delimiter or not. if not, the file should not be processed. Is there any way that i could handle this scenario using shell Script. Can anyone please help me.

Thanks in advance..

Record length 30 weeks 1 day ago

Hi,

The record length may be differ in afile. I want to display the records if the record length is not equal to 50 using sed/awk command.

Thanks in Advance

Hi all,

For no particular reason, I would like to use awk on a file that contains multiple columns, but let's say only columns 1 and 2 have some text values, and the remainder of the line contains text that I would like to treat as one column, considering I have spaces as delimiter for the columns, e.g.:

Code: alpha 200 this is a comment for this record bravo 400 this is another comment for

CSV Delimiter Settings 27 weeks 5 days ago

Hi All,

I am really new to Shell Scripting and would appreciate any help here.

I have a script that runs throguh a cron job on a daily basis, problem is when the file is attached and e-mailed, it uses a comma delimiter to seperate fields.

How can I prevent the script from using a comma delimiter, maybe even changing the delimiter to something like a pipe delimiter?

Hi,

To load a big file in a table,I have a make sure that all rows in the file has same number of the columns .

So in my file if I am getting any rows which have columns not equal to 6 , I need to delete it . Delimiter is space and columns are optionally enclosed by "".