Put string to table


#1

Hi Guys,

I would like to please about small instrucion.
I got table:

And im cutting string to specific part as is on the table…
How to put specifig string to correct column in table…
String starting from 3.2 to column 3_2
String starting from 3.3 to column 3_3
String starting from 3.4.1 to column 3_4_1
and here is a gap…
coz string 3.4.2. and 3.4.3 dosent exist in this case but can be in the future…
String starting form 3.4.4 to cloumn 3_4_4
String starting from 3.4.5 to clounn 3_4_5

Many thanks for help,
Regard
@fudi5


#2

@fudi5 Check this.

SplitString.zip (3.1 KB)

Let me know if it helps. May not be the best approach but i believe it should work if each of those string start with that id and are in new line.

Thanks,
Rammohan B.


#3

Hi @Rammohan91,

I got the same solution right now but something is wrong coz in my case element in table are wrong assign.

Many thanks for you :slight_smile:
Regards
@fudi5


#4

I got question… if anyone can told me.

If i got:

StrValue=StrValue.Split({“Section2”,“Section3”},StringSplitOptions.None)(1)

and cutting element in current case does not exist so can i identify this element like a empty or null and return some tekst like “There is no data” ???

Many thanks for help,
Regards,
@fudi5