replace and get the data that I want by using; replace all occurrence & split commands

[former_member770182]

Hello experts, I'm currently working on parsing the data.

My text looks like this: 'A5**180000****100***798**********APK'.

First, I used; replace all occurrence of '*' in text with ` `.

So, I could get; A5 180000 100 798 APK.

Then, I want to retrieve the data 'A5', '180000', and '100' for the further process.

I used split text at space into lv_head lv_num lv_code.

However, I only get A5 as a result.

How do I get first three elements after using replace command?

Any suggestion would be appreciated other than split command as well.

Thanks,

[former_member770182]

Hello experts, I'm currently working on parsing the data.

My text looks like this: 'A5**180000****100***798**********APK'.

First, I used; replace all occurrence of '*' in text with ` `.

So, I could get; A5 180000 100 798 APK.

Then, I want to retrieve the data 'A5', '180000', and '100' for the further process.

I used split text at space into lv_head lv_num lv_code.

However, I only get A5 as a result.

How do I get first three elements after using replace command?

Any suggestion would be appreciated other than split command as well.

Thanks,

[venkateswaran_k]

are these * are fixed one..

meaning between A5 and 180000 - is always two * only .- example

or these *s are variable length?

[former_member770182]

That is just an example and could be changed in different length.

Sorry I didn't specify.

[former_member770182]

Sorry, I just figured it out.