Remove square brackets 2

[dinster]

Hi all i have got data from oracle and placed it in access table.... in some of the fields it has square brackets. How do i get rid of the square brackets and replace them with carriage return.

Is there some sort of function i could do to loop through each field and replace the squares boxes and do carriage return?

Could some1 give me a small example to get me started?

many thanks

 

[oharab]

Easiest way is to use the built in Replace function;

Replace(Replace(yourdatahere,"[",""),"]",vbCrLf)

This replaces the opening square bracket with nothing, then the closing with a carriage return.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

 

[dinster]

Hi ben thankyou for replying....

I have tried that with slight alteration and nothing happens

test: Replace(Replace([ADMDATA_Diag],"[",""),"]","vbCrLf")

 

[TomCologne]

vbCrLf is a constant so remove the quotes.

TomCologne

 

[dinster]

Hi thanks it worked

also used this which is similar to wat u were saying

EXAM_Neuro1: Replace([EXAM_Neuro],Chr(10),Chr(13) & Chr(10),1,-1,1)