General information
Category:
Coding, syntax & commands
>I have a table that contains 7 columns. The first 6 columns contain payroll deductions. The 7th column has information on types of deduction being held in the columns 1 thur 6. My problem is that I have to parse the information in 7th column. The order in which the names appear in 7th column determines which 1 thru 6 columns contain the deductions. For example:
>
>first record
>col1 = 68
>col2 = 35
>col3 = 45
>col4 = 0
>col5 = 0
>col6 = 0
>col7 = "HLTH01 CCAPE C INS" ---> need to be parse to hlth01, ccape, c ins
>
>so HLTH01 = 68, CCAPE = 35 and C INS = 45
>
>
>second record
>col1 = 50
>col2 = 60
>col3 = 70
>col4 = 80
>col5 = 0
>col6 = 0
>col7 = "HLTH01FLXD CCAPE UTWAY" ---> need to be parse to hlth01, flxd, ccape, utway
>
>so HLTH01 = 50, FLXD = 60, CCAPE = 70 and UTWAY = 80
>
>
>as you can see the names in col7 can run into each such as HLTH01 and FLXD. They can also contain spaces between name such as "C INS". How can I go about searching in the sting for a particular name and also determine what position those name are in reference to deduction columns 1 thur 6. I hope I haven't confused anyone. thanks
>
>Nick Patel
is there a finite list of accepted codes? as in 'HLTH01','FLXD','CCAPE', and so forth ?
it the longest possible code 6 characters?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only