@splitting string

Help
1

Hi team,

I have below text I need to split based on the number number after the “Item”
Item 10 Sched.line 1
Net price must be greater than 0
Item 50
Net price must be greater than 0
Item 50 Sched.line 1
A different source of supply is the fixed source for this date
A different source of supply is the fixed source for this date
Item 70
Net price must be greater than 0
Item 70 Sched.line 1

2

Can you elaborate with input and output from the above strings

3

Hi Indra,

I want text between item 10 to 50 and 50 to 70 but numbers will vary sometimes it is like item 20 and next 30 and 90.
I need text between item numbers to make decision.

Thanks
Girish

4

Sometimes item 10
And item 10 schedule come but still I have to consider this a entire string till next item number.

5

Hello, I guess you need to find the item, so it wont matter in what position it is. I think you can use substring for this. Give me an example. Of. Your data please

6

Hi @beesheep,

I can find the items but I need text between each unique item to make decision.

Net price must be greater than 0
Item 50
Net price must be greater than 0
Item 50 Sched.line 1
A different source of supply is the fixed source for this date
A different source of supply is the fixed source for this date
Item 70
Net price must be greater than 0
Item 70 Sched.line 1

Thanks
Girish

1 Like
7

PFA @beesheepTest.xaml (1.7 MB)

1 Like