How To Parse Specific text from String Data

[zaidan]

I have set of data in one column contain spesific code of meteorological element, but each data does not have same format, what i want to do is to get some text(data) by parsing from the code and put them in different column with certain category.

Example :
data: (in column A)
METAR WARR 120000Z 29006KT 6000 HZ FEW020 25/24 Q1008 NSG=
METAR WARR 120100Z 00000KT 7000 SCT020 25/24 Q1008=
METAR WARR 120130Z 28004KT 240V300 8000 HZ NSC 27/24 Q1009=
METAR WARR 121230Z 00000KT 7000 RA FEW020CB SCT020 24/23 Q1008=

the result i expect :
___B______C______D______E______F______G_____H_____I______J____
direction_speed_Visibility_Weather_amount_height_temp_D.point_Pressure
__290_____06___6000_____HZ____FEW___2000___25____24_____1008
__000_____00___7000___________SCT____2000___25____24_____1008
__280_____04___8000_____HZ__________________27____24_____1009
__000_____00___7000_____RA____SCT____2000___24____23_____1008

Thanks for any help.

 

[Peter_SSs]

In future, please post any clarification or follow-up information in your original post. Refer to the Posting Guidelines particularly points 21-23. In this case I will lock this thread since you have provided additional data in the duplicate thread