Alphanumeric from string array

[pulkit2031077]

I want to extract only the alphanumeric part from the string array that is after the equal sign and also put it back in a array.String array is attached below

[GerdW]

Hi pulkit,

---

@pulkit2031077 wrote:

I want to extract only the alphanumeric part from the string array that is after the equal sign and also put it back in a array.

String array is attached below

---

No, there is no string array. There is just a JPG image…

What is "alphanumeric" in your definition? Does it include the opening bracket? Does it include the asterisk/plus signs? What about the semicolon?

What do you want to "put back in a array"? Which array?

Suggestion:

• You can use the MathPattern function on each string array element to split at the "=" char. Or use the SpreadsheetStringToArray with "=" as separator…
• Use a loop to process all array elements…

[LVNinja]

One way to implement this is using a FOR loop. it automatically "indexes" the input array passing one item at each iteration

 Inside the loop, the string uses the Match patthern to find for the string after the equal sign. 

The remaining string, will use the Match pattern again to extract the string BEFORE the sign ";"

THe output of the loop will automatically index the strings producing the output string 

[PalanivelThiruvenkadam]

Few Tips;

Use String Match Pattern to extract the Values After (=) Sign.

Convert the Extracted String and Convert to byte array which will give you the ASCII values of the String Characters.

Use Loops and Case structure to concatenate only Alphabets and Numbers (Alphanumeric).