Hi,
I am trying to find the last index of a character within my text. I have tried to use LastIndexOf but it doesn’t seem to be available?
Any other way I can achieve the result I wanted please?
Thanks.
Hi,
Can you give us a specific example?
Regards,
Below is a sample text extract.
1213633
0107262
1200357
0216061
0302091 38 1000 0712345 01
38 0612345 02
38 2000 0540931 03
38 1523456 02
38 2123 3631456 02 ABC LIFE LIMITED
CAR MONITOR LIMITED
SOUTHERN STAR INSURANCE LIMITED C…
FINE SPORTS LIMITED
THE NORTH COUNCIL 16 Jan 2015
20 Jul 2009
15 Oct 2004
08 Oct 2009
22 Dec 2014 Active
Active
Active
Active
Cancelled Transactions
Transactions
Transactions
Transactions
Transactions
What I wanted is to:
1. extract the numbers right before the ‘38’ part of the extract. Note: the ‘38’ number is the only number combo that is constant in that number sequence, i.e.
1213633
0107262
1200357
0216061
0302091
- extract all the text or number sequence that has the ‘38’ sequence. Note: the ‘38’ sequence will have a max 18 character limit (For unknown reason some text were missing in the extract) i.e.:
38 1000 0712345 01
38 0612345 02
38 2000 0540931 03
38 1523456 02
38 2123 3631456 02
3. extract all the text before the first occurrence of the ‘Transaction’ word, i.e.:
Active
Active
Active
Active
Cancelled Transactions
@redanime94
you want index for every line?
@redanime94
highlight the text for which you need index.
Hi @Vaibhav_Rajpoot_17 - it is already in the description…