Too difficult for me, please help.

[Menno]

I download data from a SAP table into an excel spreadsheet (2000), one
field of which contains a string like:
A=1,a=5,H=/H/<ip>/S/sapdp97/H/oss001,S=01,M=000,U=OSS_RFC,Z=CPIC,X=LB

This string can contain values for A, a, B, G, g, H, I, i, L, M, N, N,
O, Q, R, S, T, u, U, X, Z in the form A=<value> delimited by comma's.
Not every string includes all options in which case it is just
omitted.

For each row I would like to copy the values into columns with matching
headers.

Looks like a nice enough challenge, but too hard for me to solve
quickly. Thanks!

 

[swatsp0p]

I will assume you import your data into column A. Beginning in column B
(say row 2) enter the values to look for, e.g. "A=", "a=", ....."X=",
"Z=" should run through column V per your example of "A, a, B, G, g,
H, I, i, L, M, N, n, O, Q, R, S, T, u, U, X, Z".

With your imported data in A3, add a comma at the end of the last entry
(e.g. ....Z=CPIC,X=LB*,*) then in B3 enter this Formula:

=IF(ISERROR(MID($A$3,FIND(B2,$A$3,1)+2,FIND(",",$A$3,FIND(B2,$A$3,1))-(FIND(B2,$A$3,1)+2))),"",MID($A$3,FIND(B2,$A$3,1)+2,FIND(",",$A$3,FIND(B2,$A$3,1))-(FIND(B2,$A$3,1)+2)))

This will return "1" (the value of "A=")

copy this to C3 and it will return "5" (the value of "a=")

copy to D3 will return "" (a blank cell as there is no "B=" value)

and so on through V3 which returns "CPIC" (the value of "Z=")

NOTE: you _must_ add the comma to the end of the data string in A3 for
this formula to return the last value in the string!

Does this work for you?

 

[Menno]

Works like a charm. Thank you very much Bruce. Have a nice weekend.

Menno.

 

[swatsp0p]

I'm glad it worked for you. Thanks for the feedback, it is always
appreciated.

Cheers and a good weekend to you as well.