tab separated data

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
vanfanel
Newbie
Posts: 15
Joined: Sat Sep 11, 2004 12:38 pm

tab separated data

Post by vanfanel » Thu Dec 01, 2005 11:12 pm

Is it possible to parse out tab separated data using Separate command?
Top
Me_again
Automation Wizard
Posts: 1101
Joined: Fri Jan 07, 2005 5:55 pm
Location: Somewhere else on the planet

Post by Me_again » Fri Dec 02, 2005 12:49 am

I don't have any data to test it on but try:

VBSTART
VBEND
VBEval>vbTab,tab

then use %tab% as the delimiter in the Separate>
Top
User avatar
Marcus Tettmar
Site Admin
Posts: 7395
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:
Contact Marcus Tettmar

Post by Marcus Tettmar » Fri Dec 02, 2005 7:05 am

TAB is already a system variable (added in 7.4). So just do:

Separate>string,TAB,fields
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
Top
Post Reply

Return to “Technical / Scripting”

Sign up to our newsletter for free automation tips, tricks & discounts