does anyone know of any easy way using regular expressions to parse out these fields, i will be evaluating one line at time..below are some examples of the lines i will be evaluating
this is the desired output i wish to get for each line even if they dont have data in the fields
phone#,qty,code,detail,datecode,date,amount
----------------------------------------------------
here are some examples of the source data, not all have the required fields, but will need to be accounted for using a coma
-----------------------------------------------------
2122060409, 1 POR2X /TN 212 206-0409 I 03-17-99 0.23
2122060409, 1 ALN /TN 212 206-0952/LPIC NYC /LPCX 0698/LPCA DB, 10-09-00 /PIC WTL/PICX 0555 /PCA CN, 11-15-00 T 05-02-97 14.23
2122060409, 1 POR2X /TN 212 206-0952 I 03-17-99 0.23 HTG 1 206-0404-0407 I
2122060409, 1 RXR /CX 212 206-0404/HTG 1 /CAT 3 /CTX 0327/LCC N9I /CN 01 /LPIC NYC/LPCX 0698 /LPCA DB, 10-09-00 /PIC WTL /PICX 0555/PCA CN, 11-15-00 T 05-02-97
2122060409, 1 EABDF /CX 212 206-0404/MWC * MWCH1 T 04-08-97
2122060409, 1 EABDF /CX 212 206-0404/MWC * MWCH1
this is the desired output i wish to get for each line even if they dont have data in the fields
phone#,qty,code,detail,datecode,date,amount
----------------------------------------------------
here are some examples of the source data, not all have the required fields, but will need to be accounted for using a coma
-----------------------------------------------------
2122060409, 1 POR2X /TN 212 206-0409 I 03-17-99 0.23
2122060409, 1 ALN /TN 212 206-0952/LPIC NYC /LPCX 0698/LPCA DB, 10-09-00 /PIC WTL/PICX 0555 /PCA CN, 11-15-00 T 05-02-97 14.23
2122060409, 1 POR2X /TN 212 206-0952 I 03-17-99 0.23 HTG 1 206-0404-0407 I
2122060409, 1 RXR /CX 212 206-0404/HTG 1 /CAT 3 /CTX 0327/LCC N9I /CN 01 /LPIC NYC/LPCX 0698 /LPCA DB, 10-09-00 /PIC WTL /PICX 0555/PCA CN, 11-15-00 T 05-02-97
2122060409, 1 EABDF /CX 212 206-0404/MWC * MWCH1 T 04-08-97
2122060409, 1 EABDF /CX 212 206-0404/MWC * MWCH1