adding text in spreadsheet (converted to DOS format ; newbie

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
hugoboss
Posts: 4
Joined: Tue Oct 25, 2005 6:42 pm
Contact:

adding text in spreadsheet (converted to DOS format ; newbie

Post by hugoboss »

Hello,

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?
TIA
hugoboss
Posts: 4
Joined: Tue Oct 25, 2005 6:42 pm
Contact:

just found it myself, sorry for asking

Post 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!
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post 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.
hugoboss
Posts: 4
Joined: Tue Oct 25, 2005 6:42 pm
Contact:

Post by hugoboss »

I will try that next time I need it.
Thank you!
Post Reply