03-26-2014 04:26 AM
Hello,
I am getting data like ~^1820|-93.13|+4.57|-3.20|183.62'
that all value assigned something like height, angle etc..
I want to split this string could anyone please help me How to do that.
I want in one like. 1820
a= -93.13
b=+4.57
c= -3.20
d=183.62
Thank you very much in advance.
With greetings,
Ankit.
Solved! Go to Solution.
03-26-2014 04:33 AM
Hi
Try using "Spreadsheet String To Array" as mentioned in below image
Regards,
Murali
*Kudos welcome*
03-26-2014 04:35 AM
03-26-2014 04:56 AM - edited 03-26-2014 04:59 AM
Thank you very much for your suggestion.
03-26-2014 05:00 AM
03-26-2014 05:10 AM
Thank you very much for your suggestions.
i am not gettign the first value in that case which is suggested by GerdW.
first value is after ~^ this sign.
Greetigns,
Ankit.
03-26-2014 05:14 AM - edited 03-26-2014 05:15 AM
Hi Ankit,
you should not edit message when other people have posted an answer to your (pre-edit) message…
You need to "clean up" your string by removing those two extra chars at the beginning or you may start to use RegEx functions and expressions. (I'm not an expert in RegEx, so other may chime in…)
03-26-2014 05:19 AM
Thank you very much for your reply.
But in my case it is not possible to remove that signs.
because it is by default form the instrument.
Thank you very much once agian.
Greetings,
Ankit.
03-26-2014 05:23 AM
03-26-2014 06:09 AM - edited 03-26-2014 06:10 AM
It's less scalable (so I don't exactly recommend this), but you could also use Scan From String.
Again, I recommend Gerd's solution of using the Spreadsheet String To Array after using the Substring to remove the first two characters.