Shell Programming and Scripting

Hi Folks,

I have a file without any delimeters and it is a flat file. Example,

my raw data looks: x25abcy26defz27ghi.....

Now, could you please any one help me to program to split this into variable and create a text file. I want a output as below

Name Age Number
x 25 abc
Y 26 def
z 27 ghi

on linux,

Code:

[ ~]$ echo 'x25abcy26defz27ghif33jjj' | sed 's/\([a-z]\)\([0-9][0-9]*\)\([a-z][a-z][a-z]\)/\1 \2 \3\n/g'
x 25 abc
y 26 def
z 27 ghi
f 33 jjj
 
[ ~]$ sed --version
GNU sed version 4.1.5

On HP UX,

Code:

/home/->echo 'x25abcy26defz27ghif33jjj' | sed 's/\([a-z]\)\([0-9][0-9]*\)\([a-z][a-z][a-z]\)/\1 \2 \3\
/g'
x 25 abc
y 26 def
z 27 ghi
f 33 jjj
 
/home/->

Thanks Ankel. However, I have given only the sample data. My first column has 16 digit card number and so on. Your sed command considers for a single character wise.

Please help how to proceed.

Please tell us how to differentiate Name and Number.
Else, it will not be able to parse these records

Although below code does not do the job, it should be able to point you to the right direction once you can differentiate between Name and Number. Some regular expression will be required to sort this out

Code:

echo x25abcy26defz27ghi | sed 's/\([a-zA-Z]*\)\([1-9][0-9]*\)\([a-zA-Z]*\)/\1,\2,\3\n/g'

As chihung told, you can easily modify the regexp as per your requirement. or show us the exact rule to determine how and when splitting is required.

sounds like you have a 'fixed width' field records.
do you know the widths of all the fields?

Ok, Here is the original record..

1-16 is digit cardno
17-33 is digit alternatecardno
34 is string
35-47 is alphanumeric..

like that it has 15 columns with 105 length. I know only the starting position and ending position of these 15 variables.

As well as the second raw without any delimeters it starts from 106 position of the file.

Let me know if you need further clarifications..

---------- Post updated at 07:30 PM ---------- Previous update was at 07:28 PM ----------

Yes VGersh. You r right. Please verify my last reply and help me.