split the sentence in to four parts

I have a sentence in column F. Some of the sentences contains 4 types which I want to split in to four columns in column I, J, K, L

Example given in attachment.

Please provide code with your comment about the function to understand the code.

Please Login or Register  to view this content.

Hi Jindon,

It is almost working

can you please refer 24th and 25th record in attachment. There was no 4 parts but still got seperated

saravanan1981

You need to explain the whole logic how to separate the sentence.

oh ok.

in one sentence check for
"1." "2." "3." and "4." (these are number of parts)
"1. " "2. " "3. " and "4. " (these are number of parts)
"1," "2," "3," and "4," (these are number of parts)
"1)" "2)" "3)" and "4)" (these are number of parts)

"PLEASE PROVIDE ME OPTION TO ADD MORE NUMBERING FORMATS IN CODE. MEANS I SENTENCE MAY CONTAINS NUMBERS LIKE 1/, 2/ 3/ OR 4/

we have to separate the string which starts from 1st part like "1. or 1. or 1, or 1)" OR "1) OR 2) OR 3) OR 4) and till the beginning of the second part including spaces and special characters

That what the code exactly does.

It doesn't explain about row 25/26 you added.

sentence in row 25 = JIO SA ID: 036640,036641,036642,036643,03664 PAYMENT TRANSFER REFERENCE NO:AXIS S 70460164,AXTB 983472656 TOTAL AMOUNT:16985/-

in this there is no separator number like "1. or 1. or 1, or 1)" OR "2. or 2. or 2, or 2)"

PLEASE REFER ROW2 =1)RENEWAL 2)030150 3)SBIN615300890254 4)16985
IT HAS PROPER SEPARATOR LIKE 1), 2), 3) and 4)


PLEASE REFER ROW3 =1. 1st phase 2. JIOM3LG15304 3. UTR NO. 856755129 4. Rs. 3305/-
IT HAS PROPER SEPARATOR LIKE 1., 2., 3. and 4.

So what's wrong with the results?

Is there any difference between your result and my result?

YES THERE IS A DIFFERENCE

ALL ROWS ARE CORRECT EXCEPT 25 AND 26.

25 AND 26 SHOULD RESULT SHOULD COME AS N/A because THERE WAS NO NUMBER SEPARATER. BUT 25 AND 26 TOO EXTRACTING. PLEASE FIND THE ATTACHMENT WITH RESULTS (MARKED IN RED)

I thought you that was your desired result.,,,

Change to

Please Login or Register  to view this content.