Hopefully a simple question. When I use the query builder to extract data it seems that if the data in a field is longer than 25 characters (ADDDRESS1 for example) it will wrap the data to next line, making it very difficult to get a full address without a lot of work. An example would be something like this:
Joe (tab) Blow (tab) 123 somewhere (tab) Spokane (tab) WA (tab) 99206 (tab) ect.
Bill (tab) Smith (tab) 12345 Another Address Apt (tab) Spokane (tab) WA (tab) 99206 (tab) ect.
(tab) (tab) #1234 (tab) (tab) etc. (where the # 1234 is actually part of the above address)
Jim (tab) Jones (tab) 345 anywhere (tab) Spokane (tab) WA (tab) 99216 (tab) etc.
This appears to only happen with Service Data, not in Sales (F & I)
Hope this explains my problem.
Is there a way to prevent this from happening?
Thanks in advance
Vic
Joe (tab) Blow (tab) 123 somewhere (tab) Spokane (tab) WA (tab) 99206 (tab) ect.
Bill (tab) Smith (tab) 12345 Another Address Apt (tab) Spokane (tab) WA (tab) 99206 (tab) ect.
(tab) (tab) #1234 (tab) (tab) etc. (where the # 1234 is actually part of the above address)
Jim (tab) Jones (tab) 345 anywhere (tab) Spokane (tab) WA (tab) 99216 (tab) etc.
This appears to only happen with Service Data, not in Sales (F & I)
Hope this explains my problem.
Is there a way to prevent this from happening?
Thanks in advance
Vic