Skip to Content
0
Former Member
Aug 28, 2009 at 01:18 PM

Data validation using either FCC or Mapping

27 Views

Hi Friends,

My requirment is

774.89 3.54 15.07 4.87 2.93 4.86 5.42 3.56 -18.64 15.75 5.94 2.11 4.74 5.57 4.27 15.73 -1.46 -17.19Z

768.94 &.52 17.05 6.93 3.76 3.03 4.59 2.98 -20.00 15.91 6.14 4.01 3.24 3.44 1.87 13.96 -3.01 -16.97Z 254

771.55 3.52 15.21 7.74 0.86 3.24 4.54 4.02 -15.42 17.40 9.60 0.81 2.73 6.40 6.07 20.45 2.51 -17.93Z

770.33 3.53 13.26 3.51 5.12 4.94 4.81 3.51 -19.76 12.57 4.20 4.52 4.94 2.69 0.50 13.86 -2.94 -16.80Z

770.33 3.^3 13.26 3.51 5.12 4.94 4.81 3.51 -19.76 12.57 4.20 4.52 4.94 2.69 0.50 13.86 -2.94 -16.80Z

770.33 3.53 13.26 3.51 5.12 4.94 4.81 3.51 -19.76 12.57 4.20 4.52 4.94 2.69 0.50 13.86 -2.94 -16.80Z

770.33 3.53 13.26 3.51 5.12

From the above data

1. Second line has a special character & and it has crossed more than the fixed length, so the whole line is to be removed.

2. Fifth line is also having a special character, so the whole line of record should be deleted before it updates to ECC Table

3. Last row has incomplete row or some fields are empty. So, last row should also be removed or deleted

Am working on a scenario FILE - PI - ECC (abap proxy). With the above conditions the data should be validated.

How can I fulfill this requirement?

Thanks.