Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have values in one column as below
43 side Drive, Leeds, GBR
67 Bradfield Way, Chard, GBR
345 Broadweird Road, Cwmbran, GBR
Verona Barn Chester Road, Barbridge Cheshire, GBR
21 Hulton Close, Southampton, GBR
How can I get values only
Leeds
Chard
Cwmbran
Cheshire
Southampton
Please can anyone suggest me soon please
Thanks.
If your field name is for example "Address" then write:
Subfield(Address,',',2)
let me know
subfield(MyField, ',',2) will return the part between the first and second comma of MyField.
Hi,
Subfield(Fieldname,',',2) as Newfield
Then you will get the data wat ever you want.
Thanks.
I can see the left space in the values at the starting of word. Please can suggest me how can I set this?
trim(Subfield('21 Hulton Close, Southampton, GBR',',',2))
Thanks
Mark
www.techstuffy.com
Thanks. for some of the fields it is showing address values as below.
Input
Apartment 45, 45 Bell Barn Road, Birmingham, GBR
Output
45 Bell Barn Road
but actual output should be
Birmingham
How can I set this please suggest