adding text in spreadsheet (converted to DOS format ; newbie

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

adding text in spreadsheet (converted to DOS format ; newbie

Postby hugoboss » Wed Dec 07, 2005 12:37 am

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

Postby hugoboss » Wed Dec 07, 2005 12:53 am

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: 2162
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Tue Dec 13, 2005 11:46 am

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

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

Postby hugoboss » Tue Dec 13, 2005 7:08 pm

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


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Yahoo [Bot] and 2 guests