Search Results

Hi Srini,
sorry to confusing 1st of al.
let me give exact scenario.

1242л1242ллллллллллNлллллллллллллллллллллллллллллллллллллллллллллллллллллллллллллллллл0.00ллллллл...

each lines should have 5 fields.
not only for this file my requirement is also about each row should have mentioned number fields.
actual issue is , from my source system src files having newline...

Hi Srini,
thanks for your reply.
this is working for only for this input and when i tried with other files its given wrong output.
pls see below exmaple.

[E20044773]:TgtFiles> cat infile...

i have a file with some number of colums and each row have different number of fields.
now my target is supposed to be, each row should have same number of columns.
example:

src file:...

Thanks "MadeInGermany" dude.
Its working perfect.
i had chekcd for multiple scenarios and its given perfect results.

one small additional requirement.
if line is devided into morethan 2 lines...

Thanks guys for your reply.
but there is no such limitation tht always last field ends with '000'.
its just an example.
the last field may be a description or alpha-numeric.

so can't go with...

we are not supposed to replace every 5th delimeter with newline charector.
expected result is after every 5fields the data should come in new row(line).

thank you

---------- Post updated at...

thanks akshay for reply.
its again same issue.
the expected result is , after 5th field delemeter should come.

"hi","there","how","are","you?",
"It","was","great","working","with",...

Hi below is my file.
cat input.dat
101,abhilash,1000
102,prave
en,2000
103,partha,4
000
10
4,naresh,5000
(its just a example file)

and my output should be:
101,abhilash,1000...

In the above scenario the last delimeter is missing in the output.
LAST COLUMN SHOULD HAVE DELIMETER AS WELL
If file is like this:
...

Awesome.
It worked.
It may simple but helps me much.
Thanks Makarand Dodmis for quick response.

Hi,
I have one problem scenorio as below.
my source file is :
cat input_file.
"hi","there","how","are","you?","It","was","great","working","with","you.","hope","to","work","y ou."

my output...