Importing Text Field with Delimiter in Text - Concatenation?
Posted by Brian P on June 06, 2001 9:54 AM
When I import data into excel, one of the text fields (column) has tabs (the delimiter) in the text. When I import it all of the other data goes into the columns in excel fine but this text field ends up in many columns could be 30 columns. I usually move this field to the last field and use concatenate to create a single field. Is there a better way to do this? I get tired of concatenating so many fields. When I use concatenate I do something like concatenate(b1,c1,d1,e1,f1)
Thanks
Brian
Posted by Ron on June 06, 2001 10:12 AM
If the data is of similar width in each field, you could choose the fixed width file type and adjust the columns and place the breaks where you wish. Just a thought.
Posted by brian p on June 06, 2001 10:16 AM
I can't use fixed width. I also tried importing twice. Once with all data and the second time selecting do not import all columns except for the last - wish I could use delimiters for all columns except the last and use fixed width on it.
Any other ideas?
Posted by Barrie Davidson on June 06, 2001 11:52 AM
Can you change the delimiter in your source file?
Posted by Brian P on June 06, 2001 5:21 PM
It took me awhile but I figured out a way change the delimiter (not to one of my choice unfortunately) It imports negative number incorrectly - with the minus sign on the right -and spaces on the left so excel thinks its text...but thats easy to fix. Thanks guys!
