Jump to content
Macro Express Forums

Setting Interger Value By Position Of Tab


Dan H
 Share

Recommended Posts

I can easily seperate a comma deliminated text file out into it's component variables... ie "test1,test2,test3,test4" into T1, T2, T3, T4 by using the set interger value by posistion of text with value of ",".

 

My current problem is that I need to do the same for "test1 test2 test3 test4" but don't know how to search for value equal to the TAB. Does anybody know how I can do this? Or know if a app that will convert a tab deliminated file to common diliminated quickly?

Link to comment
Share on other sites

Use the Set Variable to ASCII Character command. The resulting string can be used like any other string. In your case, the string created will be a TAB character, which is ASCII 009.

Variable Set %T9% to ASCII Char of 009

<ASCIIC:9:1:009>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...