AnsweredAssumed Answered

Text Function Help (Search and pass position info on)

Question asked by FlorianWiegand on Apr 22, 2013
Latest reply on Apr 24, 2013 by FlorianWiegand


Text Function Help (Search and pass position info on)


     Dear Forum,

     i need some help regarding text functions. The following is an extract of a MySQL Database Collumn which is generated by the Magento webshop and shows custom options for a product:


a:2:{s:15:"info_buyRequest";a:6:{s:4:"uenc";s:124:"aHR0cDovL3NjYy5zaG9wLm52cy5pbnRyYS9zY2NzaG9wL2luZGV4LnBocC9hdmFpbGFibGUtcHJvZHVjdHMvZXh0ZW5zaW9uLXBhY2suaHRtbD9fX19TSUQ9VQ,,";s:7:"product";s:2:"58";s:15:"related_product";s:0:"";s:7:"options";a:18:{i:176;s:19:"Application Florian";i:174;s:25:"Application Owner Florian";i:196;s:18:"Clarity ID Florian";i:175;s:11:"SID Florian";i:181;s:3:"347";i:190;s:11:"GCM Florian";i:186;s:16:"NewScale Florian";i:189;s:3:"357";i:177;s:13:"rPerf Florian";i:178;s:21:"Additional GB Florian";i:180;s:16:"SAN High Florian";i:179;s:20:"SAN Standard Florian";i:187;s:17:"VG and FS Florian";i:182;s:21:"SAP Flashcopy Florian";i:185;s:3:"354";i:184;s:3:"353";i:191;a:2:{


Every data entry changes the layout of the text saved. What i need, however is the following in a calculation:

1. Search Text for Value "s:19"  If value is not found set field to "No entry was made"

2. Move 2 spaced to the right

3. Select Text to next " sign

4. Store in Field

The result should be the following text: Application Florian

Thank you for all help