Displaying only parts of a column

[musini]

Hi All,

I have a string column and the lenght of the colun is around 100 charecters and not fixed to each record. Below is an example of how the column looks like.

'abc'1234'/abc''def'lombard'/def''ghi'dr'/ghi'
'abc'235'/abc''def'illinio'/def''ghi'st'/ghi'
This is just an example and all the records will have same data inside the single quotes, now in the report, I have to DISPLAY ONLY THE DATA WHICH IS NOT IN SINGL QUOTES which looks like the data below.

123 lombard dr
235 illinio st

Please help me with this. Thanks in advance.

M

 

[Madawc]

You could use SPLIT based on a single-quote. Stitch together the even-numbered fragments. Something like

Split({your.field}, "'")[2] & Split({your.field}, "'")[4] & Split({your.field}, "'")[6]

You would also need to use UBOUND to find out how many fragments there were.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10