Shell Programming and Scripting

Thanks Rdrtx1 for your efforts I am newbie on Unix.. Basically a Datawarehouse guy.. So again thanks..
BTW do we require to create specific schema file in this scenario.

In this example solution yes. I think the schema file is easily maintainable if it needs to be updated.

Okay..it would be really great if you can please share sample schema file for the example that taken earlier.. "pardon me if i'm asking too much"

---------- Post updated at 02:17 PM ---------- Previous update was at 02:10 PM ----------

One more thing would require your input... Will the script that you mentioned be able to put comma (delimiter) for field which for which no data is there example -

Code:

Sunilbassi031012345678901234567890123456789
Sunilbassi03101234567890123456789
Sunilbassi0310123456789

That is for 2nd and 3rd record.. Will all of them will be having 5 commas(delimiter)

for the example the output will be like:

Code:

sunil,bassi,031,0123456789,0123456789,0123456789
yyyil,bassi,031,0123456789,0123456789,
xxxil,bassi,031,0123456789,,

printf can take max length aruments. But it feels like a perl or C/C++/JAVA level task. But bash has substring: ${parameterffset:length}, so just read the lengths into two arrays: length and offset, and go through them taking apart every line.

Thanks Rdrtx1, could you please help me by providing the schema file(Or any sample for reference) for the mentioned example.

The inner loop of any solution is a for every line for n = 0..max print substring of line offset[n] length[n]; if n = max then print lsep, break else print fsep continue. Make sure your solution is stable for short lines (truncates any partial field, missing fields all go blank). Setup will be to take in the field length file and set offset[0..n] and length [0..n] using length. It can be argued that recalculating offset on the fly might be faster than fetching it from an array. Try both and see, if speed is still an issue. I would write it in C as a state machine copying one byte at a time c = getchar(); . . . putchar( c ) and inserting field separators as lengths are exhausted. That is about as fast as it gets.