Parsing this...

[patgenn123]

Good afternoon everyone.

 

I wanted to parse something like this:

 

2bc250@gmail.com

 

The split string at the "@" is easy, but I am further trying to parse the 2bc250 into "2bc" and "250".

 

How can I go about doing that?

 

Pat

[acantor]

The answer depends on what exactly you are trying to do. Split the username after the third character? Or between a vowel and consonant? Something else? It's not clear from your example. But it sounds interesting…

[Cory]

Variable modify string, copy part of text from 1 to 3 then delete the same part and continue. But like Alan said it would be better if you could tell us what the criteria is.

[patgenn123]

OK. Sorry it took so long to get back with you.

 

Sometimes the number part could be 4 digits, but the letter part seems to be always 3 digits. So I want to split it between the letters and numbers.

 

So what it boils down to is, I want the macro to detect when the letters end and the numbers begin no matter the number of numbers or letters after the first number.

 

Pat

[arekowczarek]

OK. Sorry it took so long to get back with you.

 

Sometimes the number part could be 4 digits, but the letter part seems to be always 3 digits. So I want to split it between the letters and numbers.

 

So what it boils down to is, I want the macro to detect when the letters end and the numbers begin no matter the number of numbers or letters after the first number.

 

Pat

 

Well, if I understand correctly "2bc" is the letter part and "250" is the number part.

 

If so what is "2" doing in the letters part? Is there always one digit in the front of the letter part?

If thats the case would it be reasonable to assume that the pattern looks like this:

<number><letters><numbers> ?

[patgenn123]

Arek,

 

Not all the time. it could be <letters> <number> too. It also could be 7 chracters not always 6.

 

Pat

[arekowczarek]

Arek,

 

Not all the time. it could be <letters> <number> too. It also could be 7 chracters not always 6.

 

Pat

 

Got it.

So you need to copy everything from the start of the text string until the last letter (inclusievly) into one string, and the rest into the other string. Is this correct?

[patgenn123]

I need to split the string in the middle and if the first character is a number, do not split it after this character rather go to the next possible "split" where letter ends and number begins.

[arekowczarek]

I need to split the string in the middle and if the first character is a number, do not split it after this character rather go to the next possible "split" where letter ends and number begins.

 

I believe that's what you're looking for:

<VARIABLE SET STRING Option="\x00" Destination="%T[1]%" Value="1ac657" NoEmbeddedVars="FALSE" _COMMENT="string to be split"/>
<VARIABLE SET INTEGER Option="\x0D" Destination="%N[2]%" Text_Variable="%T[1]%"/>
<REPEAT START Start="1" Step="1" Count="%N[2]%" Save="TRUE" Variable="%N[1]%"/>
<VARIABLE MODIFY STRING Option="\x09" Destination="%T[2]%" Variable="%T[1]%" Start="%N[1]%" Count="1"/>
<IF VARIABLE Variable="%T[2]%" Condition="\x04" Value="a" IgnoreCase="FALSE"/>
<OR/>
<IF VARIABLE Variable="%N[1]%" Condition="\x00" Value="1" IgnoreCase="FALSE"/>
<VARIABLE MODIFY STRING Option="\x06" Destination="%T[3]%" Value="%T[2]%"/>
<ELSE/>
<VARIABLE MODIFY STRING Option="\x06" Destination="%T[4]%" Value="%T[2]%"/>
<END IF/>
<END REPEAT/>
<TEXT BOX DISPLAY Title="RESULT" Content="{\\rtf1\\ansi\\ansicpg1250\\deff0\\deflang1045{\\fonttbl{\\f0\\fnil\\fcharset0 Tahoma;}{\\f1\\fnil\\fcharset238 Tahoma;}{\\f2\\fnil Tahoma;}}\r\n\\viewkind4\\uc1\\pard\\f0\\fs16 %\\f1 T[3]%\r\n\\par \\f0 %\\f1 T[4]%\\f2 \r\n\\par }\r\n" Left="Center" Top="Center" Width="278" Height="200" Monitor="0" OnTop="FALSE" Keep_Focus="TRUE" Mode="\x00" Delay="0"/>

The macro copies one character at a time from the input string, if it is a letter or if it's the first character it appends it to string#1. If it's a digit it appends it to the string #2.

 

Am I close?

[patgenn123]

Thanks Arek,

 

The string you used 1ac657 needs to be split between the c and 6 into 2 different variables.

 

The "1" needs to be disregarded if the first character is a number so it will not split it between the 1 and a.

 

Pat

[arekowczarek]

Thanks Arek,

 

The string you used 1ac657 needs to be split between the c and 6 into 2 different variables.

 

The "1" needs to be disregarded if the first character is a number so it will not split it between the 1 and a.

 

Pat

Did you run the macro?

 

It should return:

1ac

657

Right?

 

It does when I run it. Does it not when you run it.... somehow...?

[Cory]

I would go thru each character and record when it changes to a number. And I find concerting to the ASCII decimal value makes the logic easier.

[arekowczarek]

I would go thru each character and record when it changes to a number. And I find concerting to the ASCII decimal value makes the logic easier.

That was my first idea Cory, but I figured this would be faster. Going thru the chars cannot be avoided (well, half of the chars). So, since we are already going through the chars, why not sort them at that time? Isn't it easier to write? It doesn't require remembering how many chars are going into one string, and how many chars go into the other. But that's just my point of view

[patgenn123]

Hello,

 

Arek, I had to wait until I got home from work to try the scipt again. It still splits it at the 1 not beteen the c and 6. Plus, you declared the variable to be a 1 in the scrpt. What happens if I get something other than 1? There would have to be 9 other variables declared.

 

For some reason when I copied the script, it did not copy all of it to my scrpt editor.

 

Nevertheless, Cory, Arek et. all, I would like to learn how ASCII decimals work with this script.

 

Can you show me how to do that?

 

Thanks!

 

Pat

[arekowczarek]

It still splits it at the 1 not beteen the c and 6.

For some reason when I copied the script, it did not copy all of it to my scrpt editor.

But now, when you copied the the rest of it it still doesn't return

1ac

657

?

I'm having really hard time understanding this, there's no way this macro is machine dependent. Can anyone confirm, please?

 

Plus, you declared the variable to be a 1 in the scrpt.

No such thing. You are apparently reffering to line #7 in the script. "1" is not a character there, it stands for the character position - first from the left.

 

Nevertheless, Cory, Arek et. all, I would like to learn how ASCII decimals work with this script.

Can you show me how to do that?

Cory has much more knowledge in this topic, and he surely can explain it better if he makes time.

[patgenn123]

Arek,

 

It works now. For some reason, there is a ton of blank "text types" that fill the script as it's copied. It happened at work and it happened at home when I copied your script and pasted it into the script editor.

 

I apologize. It works.

 

Should I submit this as a website bug?

Hahaha....

 

Pat

[arekowczarek]

It works now. For some reason, there is a ton of blank "text types" that fill the script as it's copied. It happened at work and it happened at home when I copied your script and pasted it into the script editor.

 

I apologize. It works.

 

Should I submit this as a website bug?

Hahaha....

 

Pat

I can't reproduce this Pat. It hasn't ever happend to me. When I copy and paste this script (any script) into a macro it never adds any empty text type commands.

Does it happen to all the time, with every script, consistently? I can't think of a reason for it to happen... I wouldn't mind seeing a screenshot of the script with the extra commands.