Page 1 of 1

adding text in spreadsheet (converted to DOS format ; newbie

Posted: Wed Dec 07, 2005 12:37 am
by hugoboss

Back to trying out textpipe ..
I have an excel sheet in which I need to add a path before an imagename in a selection of cells(column). I have put the column at the beginning of the sheet and have converted to delimited DOS format to make it a textfile.
How do I add this path to the very beginning of each line?

just found it myself, sorry for asking

Posted: Wed Dec 07, 2005 12:53 am
by hugoboss
I suppose my column at the beginning and conversion to DOS were the right thign to do. All I needed to add was a left margin filter ..
WHAHOO just what I wanted , great tool!

Posted: Tue Dec 13, 2005 11:46 am
by DataMystic Support
If the column wasn't at the left hand side of the file, you could also use an Add Left Margin filter inside a Restrict to Delimited field filter.

Posted: Tue Dec 13, 2005 7:08 pm
by hugoboss
I will try that next time I need it.
Thank you!