To use Char(13) in a query

[Hemish]

Hi i have a whole table full of address which i have extract from Oracle and i want split the addresss in to different fields. Eg Address1, Address2, Town, Country, PoctCode. At present everything is in 1 field. When i have imported the data the Address field looks like below

4 CRESCENT WEST(sqaure symbol) CLEVELYS (sqaure symbol) BLACKPOOL (sqaure symbol) LANCS.

I know you have to use the char(13). Has anyone got anyidea how to write this in a query or vba

Thanks

 

[mresann]

Try the split function first.

strText = Text1.Value
Split(strText, chr(13))

NOTE: You may have to add line feed (chr(9)) to the split variable, as in

Split(strText, chr(13) & chr(9))

This will create an array variable strText. You can loop through it using LBound to UBound.