You will want to use strstr() function to locate the location of the first |, then use substr() to grab 0 to the result of the first |, then you will want to do the some thing with that 'chunk' to pull out the 3 values that are , separated. Once you have everything separated into 3 fields, you want to do a phase 1 (using `!) push to form2, then repeat process as many times as necessary to get through your list.
Thanks a lot Longwing. I have implemented this logic and it's working fine.
If you dont mind can you tell me the process or logic you implemented.
i have a similar requirement.