Hi All
My first post here, hope someone can help me?
I have a table named SL_ADDRESSES and a field in there named (AD_ADDRESS. This has 4 lines or so of data all with carriage returns at the end of each line. When i select the AD_ADDRESS field all data is in one field. Is there a way to separate this into separate fields based on lines of data before the carriage return? Really am stuck.
Thanks
My first post here, hope someone can help me?
I have a table named SL_ADDRESSES and a field in there named (AD_ADDRESS. This has 4 lines or so of data all with carriage returns at the end of each line. When i select the AD_ADDRESS field all data is in one field. Is there a way to separate this into separate fields based on lines of data before the carriage return? Really am stuck.
Thanks