Remove Space and get the string inside another string

[GN0001]

I have rows with street numbers and name of streets:

123 Misssion Viejo Ave

S 12487 Lake forest Str

4566 W Santa Ana Circle

The text has a space in each row in the beginning of the text,

I need to remove the space from the beginning of each address

I used trim and clean functions, they didn't work.How to remove the space from the beginning of each address in each row?

I need to extract only the name of street? How?

I used find and mid function. It helped, but I am looking for some function/ functions that pulls only street name. Any help?

Thank you for lasting support.

GGGGG

 

[shrivallabha]

Hi 5G,


Is your case similar to this link and help you solve:

http://www.rondebruin.nl/clean.htm


If yes, then it could be non breaking space in your data (CHAR(160)) causing the issue. TRIM and CLEAN don't work on these.

 

[GN0001]

Thank you very much, This definitely helps. GGGGGG